Posted by Michael Fesser on 10/27/07 20:46

..oO(mantrid)

>ok
>I found it
>
>echo date('d-m-Y', strtotime($selldatetime))
>
>seems to work

It does, but often it makes more sense to let MySQL return an already
formatted date. Have a look at the DATE_FORMAT() function.

The main reason is that it avoids the conversion of the date to a Unix
timestamp. These timestamps are much more restricted in range (typically
1970-2038, back to 1902 with negative values) than MySQL timestamps and
should be avoided when they're not really necessary like in this case.

And just in case your script still has to work with Unix timestamps, the
DB can also do this conversion work for you with UNIX_TIMESTAMP(). I
would prefer that instead of a strtotime() call.

Micha

[Back to original message]