List:General Discussion« Previous MessageNext Message »
From:<Amit_Wadhwa Date:November 5 2004 4:13pm
Subject:RE: Changing Date Type
View as plain text  
Because im reading data from another source which is always going to be
in this format, and then inserting into the database.
Thought if there was a way I could escape having to change the format
before I insert into mysql...
Sorry abt the high importance, it was turned on by default in my editor.

-----Original Message-----
From: Martijn Tonies [mailto:m.tonies@stripped] 
Sent: Friday, November 05, 2004 9:44 PM
To: Wadhwa, Amit; mysql@stripped
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.

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,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS
SQL Server.
Upscene Productions
http://www.upscene.com


> > I know that defining a Data datatype in a table renders the date in 
> > the form that the database is set to, Ie. yyyy-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 not want to change my other tables or their settings, is this 
> > possible?
>
> Isn't that just a _display_ format?
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL & 
> MS SQL Server.
> Upscene Productions
> http://www.upscene.com
>
>


Thread
Changing Date TypeAmit_Wadhwa5 Nov
  • Re: Changing Date TypeMartijn Tonies5 Nov
RE: Changing Date TypeAmit_Wadhwa5 Nov
  • Re: Changing Date TypeMartijn Tonies5 Nov
  • Re: Changing Date TypeDuncan Hill5 Nov
RE: Changing Date TypeAmit_Wadhwa5 Nov