RE: [PHP] Re: date format

2002-04-27 Thread John Holmes
No...Do it in your query. Use DATE_FORMAT in your query. ---John Holmes... > -Original Message- > From: George Nicolae [mailto:[EMAIL PROTECTED]] > Sent: Saturday, April 27, 2002 12:43 AM > To: [EMAIL PROTECTED] > Subject: [PHP] Re: date format > > try > > $date="2002-04-27"; > > ech

Re: [PHP] Re: DATE FORMAT ISSUES

2001-10-22 Thread Beeman
That worked. Thanks a lot... You rock -Beeman "Rasmus Lerdorf" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > 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 pri

Re: [PHP] Re: DATE FORMAT ISSUES

2001-10-22 Thread Rasmus Lerdorf
> 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. Yo

Re: [PHP] Re: DATE FORMAT ISSUES

2001-10-22 Thread Beeman
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. "Rasmus Ler

Re: [PHP] Re: DATE FORMAT ISSUES

2001-10-22 Thread Rasmus Lerdorf
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 t