Martijn Tonies wrote:

> 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 :-)

Actually what I find much more stable in England is yyyy-mm-dd but
working with Unix epochs in the code ( even in windows ) means that you
can DISPLAY in which ever format you want while working with numbers
that can be added and subtracted internally :)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
Treasurer - Firebird Foundation Inc.