Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Epoch to Mysql datetime format - DO NOT USE

by zakzebrowski (Curate)
on Mar 10, 2004 at 13:20 UTC ( #335430=snippet: print w/replies, xml ) Need Help??
Description: Snipet of code converts an epoch time to a MySQL datetime format. (Datetime format is : YYYY-MM-DD HH24:MI:SS ) UPDATE: Do NOT use this code snipet, instead use one of the techniques below.
sub getMysqlTime($){
  my $val = shift;
  my @ary = gmtime($val);
  my $year = $ary[5] +1900;
  my $month = $ary[4] + 1;
  my $day = $ary[3];
  my $hour=$ary[2];
  my $min=$ary[1];
  my $sec= $ary[0];
  my $time = sprintf("%04i-%02i-%02i %02i:%02i:%02i",$year,$month,$day
+,$hour,$min,$sec);
    return($time);
}
Replies are listed 'Best First'.
Re: Epoch to Mysql datetime format
by b10m (Vicar) on Mar 10, 2004 at 13:56 UTC

    I'm not sure wheter you use this to insert epoch values into a MySQL date_time field, if so, why all the hassle? You could easilly use some SQL like this:

    INSERT INTO foo VALUES(FROM_UNIXTIME(1078926984));
    --
    b10m

    All code is usually tested, but rarely trusted.
      Excellent, thanks. I was unaware of this feature in mysql. (I tend to be more of an oracle sql user than anything else, though I use mysql as a 'staging' area before code is released.) I'll use this in the future.


      ----
      Zak - the office
Re: Epoch to Mysql datetime format
by valdez (Monsignor) on Mar 10, 2004 at 13:58 UTC

    Your code could be rewritten as:

    use POSIX qw( strftime ); sub getMysqlTime { return POSIX::strftime("%Y-%m-%d %H:%M:%S", gmtime(shift)); }
    There is also Time::Piece::MySQL that does the same.

    Ciao, Valerio

Re: Epoch to Mysql datetime format
by Juerd (Abbot) on Mar 10, 2004 at 13:56 UTC

    Alternatively,

    use POSIX qw(strftime); sub mysqltime (;$) { strftime '%Y-%m-%d %H:%M:%S', localtime shift }

    Juerd # { site => 'juerd.nl', plp_site => 'plp.juerd.nl', do_not_use => 'spamtrap' }

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: snippet [id://335430]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (4)
As of 2020-07-06 02:56 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?