Re: [PHP] converting DATETIME to a readable date.

The I "now" get a date from MySQL (hehe) is to use UNIX_TIMESTAMP then feed it over to date. That way if I want to change the way the date is displayed, I don't have to touch my query syntax. And I personally find it easier to use PHP's date() function rather than MySQL's. -- Plutarck Should be

Re: [PHP] converting DATETIME to a readable date.

Brian Clark <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... | Hi DRN, | Try this and see if it functions correctly: | | | That works great, thanks Donald -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For addition

Re: [PHP] converting DATETIME to a readable date.

On 14 Apr 2001 17:31:02 -0700, DRN <[EMAIL PROTECTED]> wrote: >$date = $row["date"]; > >$new_date = date("l, j M Y, G:i:s", strtotime($date)); >~~ > >but I cannot get this to work :(, I get an "unexpected error in >date()" At a guess strtotime() is choking on the format MySQL used to return the d

Re: [PHP] converting DATETIME to a readable date.

Hi DRN, @ 8:34:08 PM on 4/14/2001, DRN wrote: ... > $date = $row["date"]; > $new_date = date("l, j M Y, G:i:s", strtotime($date)); > ~~ > but I cannot get this to work :(, I get an "unexpected error in > date()" ... Try this and see if it functions correctly: Your original code gives me th