Timestamp problem

[Anon]

What I would like is to use the timestamp from my db and format it nicly. E.g. When you just echo out the timestamp is does it in the YYMMDD - HHMMSS format (i think). What I would like is to just display the HHMMSS part of it. I have tried to use date("H:i:s"); function with PHP, but that just display the current time and not the time from the timestamp.

Any ideas?

[tony_l]

Well if you are using a MySQL Database, they do have a function that outputs it into a readable format such as month/day/year and many other types of formats.

Otherwise, (since I am unfamiliar with other types of databases) You can convert the database date or datetime entries by using the strtotime() function. You can find the write up on that function here -

http://www.php.net/manual/en/function.strtotime.php