Actually, you can insert the date with hyphens, also..so '2003-09-12' will work. and if you're not going to use the time, don't use a datetime datatype...just use date.
On Mon, 2004-01-05 at 14:28, Donald Henson wrote: > 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]