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