I have a mysql database running under NT4. The date format (yyyy-mm-dd) is read from the mysql default value and displayed in my standard sql generated asp pages in the mm-dd-yyyy format. However, in the update statement, even though the code executes without errors, the inserted date is inserted as 0000-00-00, apparently because of the display format.

Is there a way to code the variable the $year, $month and $day to the mysql date format? I can extract the portions using session variables but the insertion part is driving me nuts.

Thanks

Bob