6 messages in com.mysql.lists.mysqlRe: date
FromSent OnAttachments
Jorge Martinez05 Aug 2002 09:38 
George Georgalis05 Aug 2002 09:48 
Victoria Reznichenko06 Aug 2002 07:13 
Ralf Narozny06 Aug 2002 07:23 
nick gatsis07 Aug 2002 00:27 
nick gatsis07 Aug 2002 00:31 
Subject:Re: date
From:Victoria Reznichenko (vict@ensita.net)
Date:08/06/2002 07:13:39 AM
List:com.mysql.lists.mysql

Jorge, Monday, August 05, 2002, 7:38:45 PM, you wrote:

I need insert a Date in the format Fri Oct 3 21:23:45 GMT 1997 in a database, but mysql not resonse;

If you want to use DATE and TIME column types you can't store data in the above
format.

how convert the date at the format --/--/----

Take a look at DATE_FORMAT() function: http://www.mysql.com/doc/en/Date_and_time_functions.html