Re: [PHP] datetime formatting problem

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 [as in what

Re: [PHP] datetime formatting problem

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. i'm using

Re: [PHP] datetime formatting problem

[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:

RE: [PHP] datetime formatting problem

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 Daniel Clark

RE: [PHP] datetime formatting problem

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

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 PROTECTED] wrote in message news:[EMAIL PROTECTED