use strict;
use warnings;

open my $otherfile, ">", "otherfile.txt" or die $!;
print $otherfile scalar localtime, "\n";
[download]

my $date = qx/date/;
[download]

use POSIX 'strftime';
my $today = strftime '%d-%m-%Y', localtime;
[download]

$tt1=date(114454234); I am not able to convert from_unixtime value to date format. In database I am using timestamp value. If i insert from_unixtime value i get "0000" Using date(114454234) I am getting undefined subroutine. How should i call the date subrountine where it should be declared

Where is the date subroutine? It's not in Perl or its base modules. There is, however, a localtime function that may do what you need.

It also looks like you've asked a remarkably similar (and equally ungrammatical) question here.

emc

Insisting on perfect safety is for people who don't have the balls to live in the real world.

—Mary Shafer, NASA Dryden Flight Research Center

What did you try? Why don't you read the documentation? Do you think your computer or we here should be able to read your mind?

here is my testrun, everything works as it should - don't just make something up in your head and falter surrender if that failes, read the documentation carefully, experiment with the stuff you read and think:

mysql> create table tstest( ts timestamp not null default now());
Query OK, 0 rows affected (0.03 sec)

mysql> insert into tstest values(from_unixtime(114454234));
Query OK, 1 row affected (0.00 sec)

mysql> select * from tstest;
+---------------------+
| ts                  |
+---------------------+
| 1973-08-17 17:50:34 |
+---------------------+
1 row in set (0.00 sec)
[download]

Edit: altered a word to get nearer to the intended meaning...(marked via strike out)

Timestamp from 1973???? only hour format how can it be inserted

The value you get by taking the difference of two timestamps is not a timestamp, but an intervall - and that intervall cannot be inserted as just hours - a timestamp is a defined moment in time, not an intervall - as I mentioned here you are simply using the wrong type for that column.

Please stop spamming the monastery with your rubbish postings - read

• Welcome to the Monastery! Make yourself at home.
• How (Not) To Ask A Question
and please above all, read the documentation for the tools you use, namely MySQL in this case, and try to understand the problem you are about to solve before you come up with solutions that aren't likely to work because you don't understand the problem at hand - that seems to be the case here.

I'm a bit fed up with your behaviour here - posting, multiple times, without content, in the wrong sections, creating new accounts to make the same mistakes again - you are misusing a wonderful place, and with that you are taking away from yourself the opportunity to learn something from all the wonderful, helpful poeple here - kind of sad...

regards,
tomte

---

An intellectual is someone whose mind watches itself.
-- Albert Camus

How to use the date subroutine.

Is that a question? If so, then it's missing a question mark. However the answer is "just like thus:"

my @output=date(@args);
[download]

What should be in @args and what should end up in @output depends on the actual date sub.

How to use the date subroutine and pass the value in other file

Another question? Still missing a question mark. However the answer is "just like thus:"

print $otherfile date(@args);
[download]

"How to use the date subroutine."
  Leaving out snarky comments about its object oriented interface, partner -> find_member_of_appropriate_sex
and complaints about your punctuation, look to convert seconds since the epoch to a list containing the time and date, and the various time-related functions in the Posix module, where you could take a look at strftime and asctime.