At 06:02 PM 31-01-02 +0000, you wrote:

>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?

No. Legal date literals are:

'dd.mm.yy' or 'dd.mm.yyyy'
'mm/dd/yy' or 'mm/dd/yyyy'
'dd-MMM-yy' or 'dd-MMM-yyyy' (where MMM is English month abbreviations)
'yyyy-mm-dd'

In all cases the time literals (with a blank between the date part and the time part) is
'HH:MM:SS.nnn' where nnn is milliseconds.

In Dialect 3 you also have to cast the date literals, e.g.

CAST ('19/07/2001 14:47:20.000' AS TIMESTAMP)

CAST ('19/07/2001' AS DATE)

CAST ('14:47:20.000' AS TIME)

cheers,
Helen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________