Subject Re: [firebird-support] Different separators for date and time
Author Lester Caine
Salvatore Besso wrote:

> Shouldn't FB handle different date and time separators like Windows does?

Just been stung with the same sort of problem - in windows!
Had set to YYYY-MM-DD for a job and forgot to switch back, but the
application switched to DD/MM/YYYY quite happily - and then imported all
the dates from YYYY-MM-DD as MMDDYYYY ( reversed the month and day order
). To add to the fun ALL dates just happened to be in the first 12 days
of the month - typical Murphy. So I'd rather not copy windows ;)

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

IBO does a reasonable job handling this. As long as you are doing
everything with one setting! When moving from machine to machine you get
niggles, and so the first thing in ALL my applications is
ShortDate="dd/mm/yyyy" :)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services