Re: Re: DATE FORMAT ISSUES

Are you retrieving it using MySQL's UNIX_TIMESTAMP() function? PHP's date() function needs a unix timestamp to work with. -Rasmus On Mon, 22 Oct 2001, Beeman wrote: > 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" <elias_bachaalany@yahoo.com> wrote in message > news:20011022140057.21068.qmail@pb1.pair.com... > > maybe you have in your database a DATE field instead of DATETIME field? > > > > "Beeman" <dbh3@mac.com> wrote in message > > news:20011022134511.14775.qmail@pb1.pair.com... > > > 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 > > > > > > > > > > > > > >