Subject Re: Date in SQL
Author Alexander V.Nevsky
--- In ib-support@yahoogroups.com, "Faruk" <farukkaradeniz@y...>
wrote:
> to the group,
> As an offer, please write down your date samples
> 31 for day
> 12 for month
> 2000 or any year for year
> so we can understand what you mean really :)
> Thanks everybody

Faruk, how FB (and IB too) interprete dates defined by string is
dependent on used in this string separator:

"/" mm/dd/yyyy
"." dd.mm.yyyy
"-" yyyy-mmm-dd

there are more acceptable formats including shorted ones, but I don't
remember all of them. This formats are hardly coded and can't be
changed through international settings in OS. So it is recommended to
transfer dates from client to server via typed parameters, not a
strings, or at least change international settings of the client to
one of acceptable formats in first lines of your programm. It is
highly recommended too don't allow to user to enter dates in TEdit
etc, but use calendar dialogs for it.

Best regards, Alexander.