select distinct unix_timestamp(‘2011-12-07 13:01:03’); select distinct from_unixtime(1323234063,‘yyyy/MM/dd HH:mm:ss’) ;