Alejandro, > I had a problem inserting a date...which format do I need to use?...I'm > using yyyy-mm-dd, but when I throw a query, the records display 0000-00-00.
You can insert a date as a string or as a number. Examples: 20030219 --> today, as a number '2003-02-19' --> today, as a string You forgot the quotes around your date. You have quite some more ways to insert date and time values; check it out: http://www.mysql.com/doc/en/Date_and_time_types.html Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php