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) => YY
[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
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
