RE: [PHP] Fw: Formatting dates (from MySQL)

2002-12-14 Thread John W. Holmes
> I was just looking at the date/time functions > (http://www.php.net/manual/en/function.time.php) and I can't seem to find > a > function that can format a date that is supplied in the format of a > DATETIME > column. > > So, I was wondering, is there a function that can format it properly or > s

Re: [PHP] Fw: Formatting dates (from MySQL)

2002-12-14 Thread Marco Tabini
You should be able to use strtotime() to transform the datetime string into a UNIX timestamp, which you can then format back using date(). However, this is a very circuitous way--either use SQL to format it or, if your DBMS supports it, have it returned already as a UNIX timestamp. The actual SQL c

[PHP] Fw: Formatting dates (from MySQL)

2002-12-14 Thread freaky
Hey there, I was just looking at the date/time functions (http://www.php.net/manual/en/function.time.php) and I can't seem to find a function that can format a date that is supplied in the format of a DATETIME column. So, I was wondering, is there a function that can format it properly or should