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:[EMAIL PROTECTED]] Sent: Wednesday, June 20, 2001 10:28 AM To: [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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]