Time convertions

On Commandline:
perl -e 'print scalar localtime(shift),"\n"' 1224687639;
Wed Oct 22 16:00:39 2008

In a script
---
#!/usr/bin/perl
# Date to timestamp (date2stamp.pl)
($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst)=localtime(time);
printf "%4d-%02d-%02d %02d:%02d:%02d\n",$year+1900,$mon+1,$mday,$hour,$min,$sec;
---
>date2stamp.pl
2008-10-26 23:43:33


To timestamp using Awk:
strftime("%Y-%m-%d %X", 1224687639)

eg
awk -F, '{OFS=","; print "\""$1"\"", strftime("%Y-%m-%d %X", substr($2,1,10))"."substr($2,11), $3, $4, $5, 0}'