> > > To insert 13/01/2007 I have to insert 01/13/2007 when do you set

that? In

> >the environmental options the >DATE is set to dd/MM/yyyy why does it

insert

> >in reverse order the day and the month?
> > > It's InterBase 7.5
>
> At 09:24 PM 2/04/2007, Martijn T wrote:
>
>
> >Cause regional settings doesn't influence how the server
> >accepts dates.
> >
> >There are several formats it accepts, all documented.
> >
> >mm/dd/yyyy is one of them.
>
> You could also say that dd.mm.yyyy is another one, and yyyymmdd is
> yet another. :-)
> Or, yes, you could force the lad to read the manual...;-)

Hey, that's why I only mentioned 1 :-)


(and the one I can remember, that is).

Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com