MySQL select timestamp as date string

Question

I have a table with the column create_time which is of type INTEGER and represents the time since epoch.

I'd like to select all rows and columns, while displaying this row as a date/time in UTC format.

How do I do that?

OMG Ponies · Accepted Answer · 2010-09-01 00:37:39Z

9

Use FROM_UNIXTIME to convert seconds since epoch to a DATETIME, which also allows you specify a format:

FROM_UNIXTIME(create_time, '%Y-%m-%d %H:%i:%s')

answered Sep 1, 2010 at 0:37

OMG Ponies

334k85 gold badges536 silver badges508 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1