timestamp format

jrolands

if i extract a timestamp from an mysql database ($row["timestamp"]), how can i output it with another format, like "dd/mm-yyyy hh:ss" ?

NogDog

Use MySQL's DATE_FORMAT() function in your query

jrolands

I tryed the DATE_FORMAT() function, and got the FROM_UNIXTIME from anoter thread, but it only returns NULL.
Any idea why?

"SELECT DATE_FORMAT(FROM_UNIXTIME(posted), '%d-%m/%Y %H:%i') AS date_formatted FROM articles;" posted column is type TIMESTAMP"

'posted' column is type TIMESTAMP

bpat1434

Why use two functions when you can literally use one:

SELECT FROM_UNIXTIME(`posted`, '%d-%m/%Y %H:%i') AS `date_formatted`
FROM `articles`

NogDog

What type of field is posted? I assumed from your original post that it was a timestamp type field. If so, then there is no need for the FROM_UNIXTIME() function, as a MySQL timestamp is not a UNIX time value. If, on the other hand, it is an integer field containing a UNIX time value, then Bpat's suggestion should be good for you.