Convert Epoch time to Date 2

[Mag0007]

How do I convert epoch time to regular date in awk? Is it possible?

I have something like this:
1144172897

 

[feherke]

Hi

If you have [tt]gawk[/tt], then with the [tt]strftime()[/tt] function :

print strftime("%c",1144172897)

Probably [tt]nawk[/tt] also has something usefull.

If you have only standard [tt]awk[/tt] I suggest to use an external command to do the conversion.

Feherke.

http://rootshell.be/~feherke/

 

[Mag0007]

Hmm.

I only have awk and nawk on my system :-(

 

[vgersh99]

not natively within awk, but....
on Solaris:

currentEpoch='1144172897'
echo "0t${currentEpoch}=Y" | /usr/bin/adb

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[PHV]

You may consider perl:
#!/bin/ksh
epoch=$1
eval $(perl -e '
($ss,$nn,$hh,$dd,$mm,$yy,$wd,$yd,$dst)=localtime('$epoch');
printf("yy=%04d mm=%02d dd=%02d hh=%02d nn=%02d ss=%02d\n",$yy+1900,$mm+1,$dd,$hh,$nn,$ss);
printf("DATE=%04d%02d%02d\n",$yy+1900,$mm+1,$dd);
printf("TIME=%02d%02d%02d\n",$hh,$nn,$ss)')
echo "$epoch:"$DATE,$TIME,$yy,$mm,$dd,$hh,$nn,$ss

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Mag0007]

I was able to get gawk and the strftime() to work. however %c only prints the current date. How do I convert a epoch number to a regular date?

TIA

 

[feherke]

Hi

Maybe I am confused, but as far as I know, that 1144172897 is called Unix time.

Would be better to show us exactly what you want to get as the conversion's result.

And [tt]strftime()[/tt] will format its second parameter, if exist, not only the current date. And [tt]%c[/tt] is for current system-wide date format, not for current date. For more on format specifiers, see man strftime.

Feherke.

http://rootshell.be/~feherke/

 

[Mag0007]

Sorry for being unclear.

On AIX:
lsuser -a time_last_login ALL

gives me something like this:
user1 time_last_login=1144279759

It seems time_last_login is a UNIX epoch time.

I want to convert 1144279759 to regular date



In awk preferably....

Perl it would be something like this:

perl -we 'print (my $time= localtime 1144279759, "\n")'

 

[feherke]

Hi

And what is the difference between the [tt]perl[/tt] and [tt]awk[/tt] results ?

[blue]master #[/blue] perl -e 'print "".localtime 1144279759'
Thu Apr  6 01:29:19 2006

[blue]master #[/blue] awk 'BEGIN{print strftime("%c",1144279759)}'
Thu Apr  6 01:29:19 2006

Feherke.

http://rootshell.be/~feherke/

 

[Mag0007]

Works!

Thanks....star deserved!