Guido,

> I have been working a long time with firebird on a german server with
> the date format 'dd.mm.yyyy' without any problems. Now the server has
> been moved to a London and there the date format is 'dd/mm/yyyy'. Now I
> get always conversion errors, when I want to use the english date format.
> Am I doing something wrong or does firebird not understand the english
> date format?

Actually, Firebird only understands a certain set of date formats,
totally independent of the server settings.

The best way, however, is to use parameters in your queries.

In case of doubt, use mm/dd/yyyy :-)

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com