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
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,
[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:
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