Re: [PHP] datetime formatting problem

2004-05-28 Thread Stephen Lake
like a charm and i'm off to read up some more on strtotime. best, m. -Original Message- From: Torsten Roehr [mailto:[EMAIL PROTECTED] Sent: Friday, May 28, 2004 2:07 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] datetime formatting problem "Daniel Clark" <[EMAIL PROTEC

RE: [PHP] datetime formatting problem

2004-05-28 Thread Matt Newell
appreciate the headsup, but all times will be from when record is inserted which will not be possible before today. thanks, m. -Original Message- From: Jordan S. Jones [mailto:[EMAIL PROTECTED] Sent: Friday, May 28, 2004 2:20 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] datetime

RE: [PHP] datetime formatting problem

2004-05-28 Thread Matt Newell
thanks a bunch torsten. it worked like a charm and i'm off to read up some more on strtotime. best, m. -Original Message- From: Torsten Roehr [mailto:[EMAIL PROTECTED] Sent: Friday, May 28, 2004 2:07 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] datetime formatting problem "Da

Re: [PHP] datetime formatting problem

2004-05-28 Thread Jordan S. Jones
[snip /] Hi Matt, try this: function formatDate($val) { $timestamp = strtotime($val); return date('M d, Y g:i A', $timestamp); } strtotime possibly will not work if your date is < 01/01/1970. [snip /] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.n

Re: [PHP] datetime formatting problem

2004-05-28 Thread Torsten Roehr
"Daniel Clark" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Isn't "date" a reserved word? date and dateTime are not reserved in MySQL and can be used as column names. > > > hi all - > > > > this is probably straight forward, but i'm learning and would appreciate > > any insight.

Re: [PHP] datetime formatting problem

2004-05-28 Thread Daniel Clark
Isn't "date" a reserved word? > hi all - > > this is probably straight forward, but i'm learning and would appreciate > any insight. > > i'm using the datetime type in mysql and have been able to successsfully > pull the data records's date, but it's failing out and giving me the > current time [a