select unix_timestamp('2012-04-04 00:59:00');
# return 1333475940
select from_unixtime(1333475940);
# return 2012-04-04 00:59:00
select from_unixtime(unix_timestamp('2012-04-04 00:59:00'));
# return 2012-04-04 00:59:00
select unix_timestamp(from_unixtime(1333475940));
# return 1333475940
Title:
MySQL date time unix timestamp
Description:
select unix_timestamp('2012-04-04 00:59:00'); # return 1333475940 select from_unixtime(1333475940); # return 2012-04-04 00:59:0...
...
Rating:
4