Helen,

If I try to insert a date like "31-07-1995", isql returns an error "conversion error from string..."
If I enter a date like "07-30-1995", FB accepts the record, and a select returns a "1995-07-30".
If I enter a date like "1995-07-30", FB accepts the input, and a select returns "1995-07-30".
If I enter a date like "30.07.1995", FB accepts the input, and a select returns "1995-07-30".

If I use my Access 2000 front end to enter data to the FB database through the XTG ODBC driver, none of the above formats is considered within range.

What am I doing wrong here ?.

TVMIA,

Klerman

----- Original Message -----
From: Helen Borrie
To: ib-support@yahoogroups.com
Sent: Sunday, May 04, 2003 10:33 PM
Subject: Re: [ib-support] XTG ODBC driver...


At 10:06 PM 4/05/2003 -0400, you wrote:
>Hello,
>
>Has anyone found problems with dates using the XTG system's ODBC driver for
>Interbase ?.
>
>I have setup this simple table in FB:
>
>customer_ID integer
>customer_name varchar(40)
>customer_dateofbirth DATE
>
>With isql, I've been able to insert data in this table, for example:
>
>insert into CUSTOMERS (customer_id, customer_name, customer_dateofbirth)
>values (1, 'John', '12-31-1962');

mm-dd-yyyy is not a valid date literal format for IB/Fb. Use this format
only for dd-mm-yyyy. Use mm/dd/yyyy if you want month-first.


>I linked the table to an Access database with the mentioned ODBC driver. I
>have tried to perform an insert from an Access query using almost all the
>date formats the XTG's readme.txt mentions, with no luck. It always returns
>an out of range ODBC error. The query is similar to the one above. But the
>data inserted with isql is shown as expected.

If you used this format with isql then it probably isn't "as expected". If
your date was something like '04-05-2002' then it would store and retrieve
that date as May 4th. If you tried '12-31-1962' you would get an invalid
date format error (because there is no month 31).

Why don't you get hold of the Data Definition Guide, where you will find
all of the valid date literal formats.

heLen



Yahoo! Groups Sponsor





To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]