RE: [PHP-DB] date
| From: | Dave Watkinson | Date: | Thu, 18 Oct 2001 09:51:43 +0000 |
| Subject: | RE: [PHP-DB] date | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-13464@lists.php.net to get a copy of this message | ||
mysql date format is YYYY-MM-DD including the hyphens)
I usually use substr() to convert it from a user's entry to the format
reqd for the database
hth
Dave
-----Original Message-----
From: ax [mailto:aznym@crosswinds.net]
Sent: 18 October 2001 10:47
To: php-db@lists.php.net
Subject: [PHP-DB] date
if i unput the values 10/10/2001 into mysql database, would mysql or php
recognize that as a date??
i am a bit confused. i inserted few dates in the above format and asked
mysql to list them by date and it does not seem to work.
any suggestions?? please :)
ax
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
For additional commands, e-mail: php-db-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net