Subject | Different separators for date and time |
---|---|
Author | Salvatore Besso |
Post date | 2005-06-10T09:44:39Z |
hello all,
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?
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.
Regards
Salvatore
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?
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.
Regards
Salvatore