I know that defining a Data datatype in a table renders the date in the
form that the database is set to,
Ie. -mm-dd by default.
I want this to remain, but for one particular table, I want to set it to
d-mmm-yy Eg. 5-nov-04 or 15-nov-04 instead of 2004-11-05 like the rest
of my tables.
I do
I know that defining a Data datatype in a table renders the date in the
form that the database is set to,
Ie. -mm-dd by default.
I want this to remain, but for one particular table, I want to set it to
d-mmm-yy Eg. 5-nov-04 or 15-nov-04 instead of 2004-11-05 like the rest
of my
Yes, but I want to be able to insert into the column dates in the format
d-mmm-yy
-Original Message-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
Sent: Friday, November 05, 2004 8:38 PM
To: Wadhwa, Amit; [EMAIL PROTECTED]
Subject: Re: Changing Date Type
I know that defining a Data
Yes, but I want to be able to insert into the column dates in the format
d-mmm-yy
That's a different story.
Question though: why?
Read some docs:
http://dev.mysql.com/doc/mysql/en/Date_and_time_types.html
btw, why is your e-mail important or high priority to me or the list?
With regards,
.
-Original Message-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
Sent: Friday, November 05, 2004 9:44 PM
To: Wadhwa, Amit; [EMAIL PROTECTED]
Subject: Re: Changing Date Type
Yes, but I want to be able to insert into the column dates in the
format d-mmm-yy
That's a different story
On Friday 05 November 2004 15:56, [EMAIL PROTECTED] might have typed:
Yes, but I want to be able to insert into the column dates in the format
d-mmm-yy
MySQL has a date format function that you can use to translate the format.
The format in the table is always -mm-dd. Use translation