Convert from UNIX_TIMESTAMP to formatted date

[paulbradley]

I'm holding a UNIX_TIMESTAMP (say, 1110715984) and I would like a way of formatting this in MySql into a date and time.

Many thanks in advance.

 

[sleipnir214]

MySQL has the builtin function from_unixtime().

Many common scripting languages which interact with MySQL have similar functions, too. An example is PHP's function date()


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[azzazzello]

The function you are looking for is FROM_UNIXTIME(unix_timestamp)

 

[lefteyecc]

If you are trying to formt a date made with php and store it in a mysql timestap then retrieve it. I think that that might be a problem. Because I read that mysql timestamps are incompatible with php timestamps. I could be wrong tho.