Subject | Re: [firebird-support] Different separators for date and time |
---|---|
Author | Lester Caine |
Post date | 2005-06-10T12:51:46Z |
Salvatore Besso wrote:
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 ;)
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
> 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 andIBO does a reasonable job handling this. As long as you are doing
> 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.
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