No it is definitely a DATETIME and the date and time are correct in the database, but when I try to format and display them the date is correct but the time is not "_lallous" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > maybe you have in your database a DATE field instead of DATETIME field? > > "Beeman" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > I have inserted the date into MySQL using now() in the query. However, > when > > I retrieve the using MySQL_Date_Format in the query the time is always > > wrong. on the other hand, if I format the date using Date() in PHP it > always > > makes the date DEC 31 1969 at 700PM. Please Help > > > > > >
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]