mktime

[neroag]

Hi
Im trying to find a way to convert a mktime () into dd-mm-yyyy.

Our database stores dates in mktime format ie .. 1253536816 & i need to convert them to date format so i can run a query on the date itself 21-09-2009

thanks all

[rincewind456]

The simplest way would be to use FROM_UNIXTIME() from within the database.