Re: [Firebird-devel] Timestamp literal with 4.0

2021-04-08 Thread Adriano dos Santos Fernandes
On 08/04/2021 05:07, Gabor Boros wrote: > Hi All, > > This > > select cast('2021.04.08 09.48' as timestamp) from rdb$database > > works with 2.5 and 3.0 but 4.0 say "conversion error from string". > > Tried with 4.0.0.2416. Is it a bug or some timezone thing? > Time hours:minutes:seconds comp

Re: [Firebird-devel] Timestamp literal with 4.0

2021-04-08 Thread Dimitry Sibiryakov
08.04.2021 10:07, Gabor Boros wrote: Tried with 4.0.0.2416. Is it a bug or some timezone thing? Dots separators in date imply format DD.MM.. You should use string in form "-MM-DD" or better to avoid date literals at all. -- WBR, SD. Firebird-Devel mailing list, web interface at