> Yeah, I select it using UNIX_TIMESTAMP(creation_datetime) and then I am
> using date("M d, Y g:ia",$myrow["creation_datetime"]) at the end of a printf
> statement but the date comes back as Dec 31 1969 7:00pm for all entries.
> When the date was inserted I used now() in the insert statement.
You should be doing:
select UNIX_TIMESTAMP(creation_datetime) as foo
date("M d, Y g:ia",$myrow['foo'])
-Rasmus
> "Rasmus Lerdorf" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > 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" <[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]
