Formatting time (perl)
Revision as of 15:45, 14 November 2005 by 161.253.47.104 (talk)
MySQL format
This function returns a time formatted into the MySQL format, YYYY-MM-DD HH:mm:SS. The time may be passed as a Unix timestamp or as the result of gmtime or localtime.
sub form_time { if(@_ > 1) { my ($sec,$min,$hour,$mday,$mon,$year) = @_; ++$mon; $year += 1900; return sprintf('%04d-%02d-%02d %02d:%02d:%02d', $year,$mon,$mday,$hour,$min,$sec); } elsif(@_ == 0) { return form_time(gmtime()); } else { return form_time(gmtime($_[0])); } }