RE: [PHP-DB] Problem displaying dates
| From: | Rick Emery | Date: | Tue, 19 Feb 2002 15:33:12 +0000 |
| Subject: | RE: [PHP-DB] Problem displaying dates | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-17053@lists.php.net to get a copy of this message | ||
Mate,
what code/function are you using to convert the dates?
what do your data look like in the table (structure, examples)?
-----Original Message-----
From: George Pitcher [mailto:fmdev@yahoo.co.uk]
Sent: Tuesday, February 19, 2002 8:01 AM
To: php-db@lists.php.net
Subject: [PHP-DB] Problem displaying dates
Hi all,
I've just moved my MySQL db and php scripts over from W2K to Linux and for
some reason my dates are coming across as '0000-00-00' even though, viewing
the db in MySQLFront, they look fine (actual dates).
When I hosted this on Win2K it worked fine.
I use a function to convert the date format from '0000-00-00' to
'dd/mm'yyyy' but have tried displaying the dates with and without the use of
this function with no success.
Any suggestions?
George in Edinburgh
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php