Thursday, June 19, 2008

MySQL - Convert MySQL date, datetime, timestamp to unix time and Vice versa

&& To convert Unix time to regular MySQL DATETIME
select from_unixtime('1213907115');
It prints '2008-06-19 16:25:15'


&& To Convert DATETIME to unixtime
select unix_timestamp('2008-06-19 16:25:15');
It prints 1213907115


&& To Convert current date & time to unix time.
select unix_timestamp();


&& To Convert a column of DATETIME type to unixtime.
select unix_timestamp(c8013_date_created) from RealTimeStatus.T8013_PROGRAM;

2 comments:

Halloween said...

Thanks mate! Quite useful

Anonymous said...

Thank u dude