> Hi,
> I have stored the date and time in mysql table with DATETIME
> type.
>
> I want to change it in to DD/MM/YYYY HH:MM AM or PM.
>
> How can I do this?
When you select the 'datetime' field from mysql use UNIX_TIMESTAMP().
Then in PHP use strftime() to format the 'datetime' field to your liking.
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
Happiness isn't something you experience; it's something you remember.
-- Oscar Levant
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
