Salvatore Besso wrote:

> I was wondering if it could be considered a bug the fact that Firebird
> accepts only "/" and "." as date and time separators. I verified this only
> now when an error was submitted to me by a user that was trying to insert a
> row with a date in the format "mm.dd.yyyy". This happened because that user
> has set "." instead of "/" as date separator in his Windows installation.
>
> Shouldn't FB handle different date and time separators like Windows does?

No, because as an application-developer you have to rely on a format
which every FB-server accepts.
If the FB-server uses some local settings you don't know, you'll be in
serious troubles...

Btw, a valid date-format is also yyyy-mm-dd

> P.S.: The error occurred in a Delphi application using FB 1.5.2 embedded and
> IBO 4.5Ai. If this is the correct behaviour of FB, I will change the date
> and time separators when the application starts and I will restore them at
> application shutdown.

Seperate GUI from Database. Accept data in a format the user is familiar
with, convert it to a date and then write it to the database using one
of Firebird's date-formats. Or use a query with parameters.

> Regards
> Salvatore

Magnus