Hi,

I think that there is a bug in TIB_Export with DATE, TIME data type from IB6
dialect 3.

I have a query

SELECT
SESJE.ID, /*INTEGER*/
SESJE.DATA, /*DATE*/
SESJE.CZAS_OD, /*TIME*/
SESJE.CZAS_DO, /*TIME*/
SESJE.CZAS/60 GODZIN,
SESJE.CZAS-(SESJE.CZAS/60)*60 MINUT
FROM SESJE

and the result of the query i something like this:

1, 2001-03-10, 20:38:00, 21:23:00, 0, 45
2, 2001-03-10, 20:38:00, 21:38:00, 1, 0
4, 2001-03-10, 20:47:00, 21:47:00, 1, 0
7, 2001-03-10, 21:47:00, 22:47:00, 1, 0

when i do the export to CSV file i get:
1,,,,,
2,,,,,
3,,,,,
4,,,,,

DBF export dosn't wokr Ok too and no matter what DataTimeFormat is.

I don't check this with TIMESTAMP.

We have TIME, DATE, TIMESTAMP data type in IB6. I think there should be
three different property for formating this fields (something like
DataTimeFormat for TIMESTAMP, TimeFormat for TIME and DateFormat for DATE).

Jason what do you think about it?

Yagi