[unixODBC-support] Firebird 2.1 ODBC Numeric and Date fields.

Nick Gorham nick.gorham at easysoft.com
Wed Mar 24 15:27:48 GMT 2010


Steve Cookson wrote:
> Hi People,
>
> In the end I gave up using ODBC for my Firebird 2.1 connection because I
> couldn't get the date or number formats to work.  Instead I used the
> DBI::Interbase driver, while it works, it is subject to occassional crashes,
> so I'd like to go back to trying ODBC.
>
> My current problem is that if I use isql on employee.fbd, (eg select first 1
> change_date from salary_history), I get:
>
> 1992-12-15 00:00:00. (Data type timestamp)
>
> if I use it on my own database, (eg select first 1
> att_patient_examination_ddt from tbl_patient_exam), I get:
>
> 22256-10-18.  (Data type date)
>
> Any ideas what I could do?
>   
Hi,

Its not much help, but I would think that was down to the driver doing a 
time/date to char conversion incorrectly.

-- 
Nick




More information about the unixODBC-support mailing list