[unixODBC-support] Firebird 2.1 ODBC Numeric and Date fields.
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?
Its not much help, but I would think that was down to the driver doing a
time/date to char conversion incorrectly.
More information about the unixODBC-support