TIMESTAMP formatting

[gazmania]

Just wondered if anyone had a really simple script that made it so when I display a timestamp instead of showing

20020924

it shows

2002/09/24

cheers

[the_Igel]

The best idea is to turn TIMESTAMP to UNIX time (select unix_timestamp(time) as unixtime), andd then apply php date() function to it:

echo date(format string, $row['unixtime']);

(in your case format string is to be 'Y/m/d').

Or you can just work with timestamp as a string:

echo substr($time, 0, 4).'/'.substr($time, 4, 2).'/'.substr($time, 6, 2);

[[deleted]]

in mysql: date_format() in postgresql: to_char()

read the manual! 🙂