On Mon, 2004-01-05 at 12:46, Ian O'Rourke wrote: > I'm very new to MySql and I'm having problems inserting dates into my tables > (via the Web using Coldfusion). The user can put the following in the field: > > 12/09/2003 > But the data returned from the database is: > > 2012-09-20 03:00:00.0 > > So I'm a bit confused about what I need to do in the insert statement so the > user can just add the date (without a time). It's probably something really > easy, but it;'s driving me nuts. >
Dates must be inserted in the yyyymmdd format. For example, your entry above should be inserted as "20031209", assuming you meant 9 Dec 2003. Also note that the date must be inserted as a string which means enclosed in double quotation marks. Don Henson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
