RE: Datetime format in MySQL

4-22 Create table Use (user char(30), LoginTime 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: Da

Re: Datetime format in MySQL

[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: http://dev.mysql.com/d

Re: Datetime format in MySQL

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 wa

Datetime format in MySQL

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 PROTE