Subject Re: [firebird-support] Date literals
Author marcus
grenzhandel@... [firebird-support] wrote:
> Hi, I'm in the progress of converting an existing application from
> Sybase SQL (11.0.3 - from the stoneage) to Firebird.From Sybase (as well
> as some other databases I work with) I'm used to entering date literals
> as 'yyyymmdd'.I keep getting "Overflow occured during data type
> conversion".Is it true, that this date format isn't recognized by
> firebird?Which is the most common date format, can you recommend any
> format?Thanks Lutz
May be this :
http://www.firebirdsql.org/en/firebird-date-literals/
is of help.

From a short skimming: Firebird uses the separator to decide, see the
chapter "Separators in Non-U.S. Dates" at the half

hth, marcus

>
>



[Non-text portions of this message have been removed]