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]