Datetime format in MySQL

2004-04-22 Thread Amit_Wadhwa
Hi All, Can you specify what format to use for the datetime column eg. in oracle you can say I wanna use DD-MMM- HH:MM:SS and so on? Regards, Amit -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Datetime format in MySQL

2004-04-22 Thread Duncan Hill
On Thursday 22 April 2004 12:56, [EMAIL PROTECTED] might have typed: Hi All, Can you specify what format to use for the datetime column eg. in oracle you can say I wanna use DD-MMM- HH:MM:SS and so on? If you read the manual, you will see that the column is formatted in one way,

Re: Datetime format in MySQL

2004-04-22 Thread Egor Egorov
[EMAIL PROTECTED] wrote: Hi All, Can you specify what format to use for the datetime column eg. in oracle you can say I wanna use DD-MMM- HH:MM:SS and so on? No. You can use DATE_FORMAT() function to format date values when you retrieve data:

RE: Datetime format in MySQL

2004-04-22 Thread B. Fongo
TIMESTAMP(12)); # This will set LoginTime as 200404221810 HTH Babs || -Original Message- || From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] || Sent: Thursday, April 22, 2004 1:56 PM || To: [EMAIL PROTECTED] || Subject: Datetime format in MySQL || || Hi All, || Can you specify what