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 way,

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:

RE: Datetime format in MySQL

You can specify the date (Datetime or Timestamp) format when creating table as follows: Type=Format - DATETIME = -MM-DD HH:MM:SS DATE = -MM-DD TIME = HH:MM:SS YEAR = TIMESTAMP --- TIMESTAMP(14) = MMDDHHMMSS TIMESTAMP(12) =