Justtechjobs.com Find a programming school near you






Online Campus Both


php-general | 2001062

[PHP] RE: [PHP-DB] Date field From: Michael Geier, CDM Systems Admin (mgeier <email protected>)
Date: 06/20/01

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 <email protected>]
Sent: Wednesday, June 20, 2001 10:28 AM
To: php-db <email protected>
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 <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>