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)

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]

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

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

use strict;
use warnings;

open my $otherfile, ">", "otherfile.txt" or die $!;
print $otherfile scalar localtime, "\n";
[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.