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.
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:
btw, why is your e-mail "important" or "high priority" to me or the
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS
> > 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