Salvatore Besso wrote:

> INSERT INTO TABLE(NUMFIELD, DATEFIELD,...._
> VALUES(1, '05.25.2005',.... <--- KA-BOOM :-)
>
> It is a feature of the application that exports a table as a SQL script and
> another application then imports that script. So I think that it is better

FYI,
in our application we have date- and time-constants for several
databases (like 'yyyy-mm-dd') and if we write these fields using
insert-statements like above, we always use something like
FormatDateTime(Dateformat[Databasetype], Date).

> Regards
> Salvatore

Magnus