Hi,

I'm trying to import data from an access database into firebird.
Tables contain a date and time field. I've made the new tables in
firebird both as TimeStamp field.
I use the sql2gdb utility to move the data from one table to another.

Now, if I look at the data exported, I see that they are exported as
eg '07/19/2001' and '14:47:20'

When I try to import these data in the tables, I get the error
message conversion error from string '14:47:20'.

How does the string has to look like so that it is correctly imported?

Is it also possible to import date strings as the format dd/mm/yyyy?

Thanks in advance,
Tom.