Re: Hi How to convert the time from mysql(DATETIME) table to the format DD/MM/YYYY HH:MM AM or PM in PHP?

> 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 */