> 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

Reply via email to