At 09:37 AM 12/09/2003 +0200, you wrote:

>Dear Helen !
>I am afraid you may have made a mistake in last examples...

Yes, Claus, you are exactly right. And I apologise for copy/pasting those
examples the wrong way around and not reading back my post before I sent it.

regards,
heLen

>I checked the date thing and I found it a bit different to your
>statement....
>FB1 no special dialect using isql ....
>
><<< If you use '9.1.2003' the date will be as 1-SEP-2003. >>>
>this is ( table: dtest dt date) stored :
>insert into dtest (dt) values ('9.1.2003') --->>>>> 09 Jan 2003 not
>1-sep-2003
>insert into dtest (dt) values ('9/1/2003') --->>>>> 01-Sep-2003
>
>other examples....
>insert into dtest ( dt ) values ('9/13/2003') ---> 13 Sept 2003
>insert into dtest (dt) values ('13.09.2003') ---> 13 sept 2003
>insert into dtest (dt) values ('13-09-2003') -- conversion error string
>insert into dtest (dt) values ('09-13-2003') -- 13 Sept 2003
>
>kind regds
>Claus Heeg
>----- Original Message -----
>From: Helen Borrie <helebor@...>
>To: <firebird-support@yahoogroups.com>
>Sent: Friday, September 12, 2003 6:33 AM
>Subject: Re: [firebird-support] Fundamental of DATE type
>
>
> > At 11:06 AM 12/09/2003 +0700, you wrote:
> > >Hello,
> > >
> > >I have a problem here, I have inserted a lot of record into my table from
> > >many processes which is one of it's field is a DATE type. The problem is
> > >about the DD and MM formatting, I am inserting using this Syntax
> > >
> > >Insert Into TABLE (dtreceive, price, ID) values ('9/1/2003', 23000, 2);
> > >
> > >I mean convert the date data from a String '9/1'2003' to input in
> > >MM/DD/YYYY format, but a lo of the data is reversed in DD/MM/YYYY.
> >
> > If you use the date literal format '9/1/2003' the date will be as
>9-JAN-2003.
> > If you use '9.1.2003' the date will be as 1-SEP-2003. There is no
> > possibility that it works sometimes one way and sometimes another, as
>long
> > as the SQL receives the correct date literal.
> >
> > However, if you are using Windows and have an application interface whose
> > date data you are converting, your own decoding algorithm can mess things
> > up if your windows locale settings provide a short date format of
> > dd/mm/yyyy. A person can go insane trying to hassle with the date
> > conversion functions provided in Delphi, for example.
> >
> >
> > >I want to know how's the most efficien way to input into the table so I
> > >will never worry about the format sequences again.
> >
> > Like Alan suggests, stick with a literal format that doesn't risk this
> > confusion. 01-sep-2003 works well (case doesn't matter) or ISO formats
> > YYYYMMDD or YYYY-MM-DD.
> >
> > heLen
> >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > firebird-support-unsubscribe@yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/