List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:November 5 2004 4:14pm
Subject:Re: Changing Date Type
View as plain text  

> 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