Re: DATE FORMAT ISSUES
| From: | Beeman | Date: | Mon, 22 Oct 2001 16:03:59 +0000 |
| Subject: | Re: DATE FORMAT ISSUES | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-71836@lists.php.net to get a copy of this message | ||
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
> >
> >
>
>