> 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