RE: [PHP-DB] Date field
| From: | Michael Geier, CDM Systems Admin | Date: | Wed, 20 Jun 2001 20:11:16 +0000 |
| Subject: | RE: [PHP-DB] Date field | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-54600@lists.php.net to get a copy of this message | ||
yyyy-mm-dd in DATE format
you can pull it back out however you like with the DATE_FORMAT command
"SELECT sometext,DATE_FORMAT(somedate,'%m/%d/%Y') AS date FROM tablename"
then you have two variables:
sometext and date
see documentation on www.mysql.com for more info on DATE_FORMAT
-----Original Message-----
From: Rosen [mailto:rosen_dm@dir.bg]
Sent: Wednesday, June 20, 2001 10:28 AM
To: php-db@lists.php.net
Subject: [PHP-DB] Date field
Hi,
Can someone tell me how do stote date field in MySQL DB ?
Thanks,
Rosen M.
--
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