Subject Re: [firebird-support] Date literals
Author Mark Rotteveel
On 14-8-2014 10:17, 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

You can use the ISO-8601 format: 'yyyy-MM-dd', optionally with explicit
typing: DATE'yyyy-MM-dd'

Note that Firebird also supports some other local formats (like
MM-dd-yyyy, MM/dd/yyyy and dd.MM.yyyy), but I think it is better to
stick to ISO-8601.

Mark Rotteveel