What is the source of the data that is displayed on the screen. If it is a field in a MySQL table and the data type for that field is either DATE or DATETIME then it will intsert/update without any manipulation.
Try doing a SELECT datefield FROM table Limit 15; outside of your ASP.NET environment. {Command line, SQLYOG, Query Browser etc.} -----Original Message----- From: Jesse Castleberry [mailto:[EMAIL PROTECTED] Sent: Thursday, November 10, 2005 1:49 PM To: MySQL List Subject: Format for saving date field. When doing an update or insert into a database with a date field, the format for the data on the screen is m/d/yyyy. However, I believe that MySQL is expecting it in the format of yyyy-mm-dd. I'm using MySQL in an ASP.Net application. Is there an EASY way to convert to the data to a format that MySQL will allow either with some MySQL function, or with an ASP.NET function? I realize that I could "rip the data apart", and put it back in the same format that MySQL is looking for, but there's got to be some easier way. Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]