Hello,

Always build a string with four digits for year in dialect 1?

For me - it is OK :)

Regards,
Dmitry Kovalenko

пт, 2 апр. 2021 г. в 20:03, Adriano dos Santos Fernandes <
adrian...@gmail.com>:

> Hi!
>
> I'm not very aware on how timestamps were working in dialect 1.
>
> But for sure CORE-6494 shows some problems.
>
> First in engine:
>
> select cast(cast('2-DEC-0083' as timestamp) as varchar(64)) from
> rdb$database;
>
> Results in string '2-DEC-83'
>
> Second in ISQL:
>
> select cast('2-DEC-0083' as timestamp) from rdb$database;
>
> Results in ' 2-DEC-  83' or ' 2-DEC-  83 00:00:00.0000' (with SET TIME).
>
> Attached patch formats day/year always with 2/4 digits.
>
> Is it ok?
>
>
> Adriano
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to