Subject | Dialect 1 vs. 3: DATE to VARCHAR CAST results in different date/time format |
---|---|
Author | Thomas Steinmaurer |
Post date | 2015-12-08T08:52:04Z |
Hello,
Executing the following in both, dialect 1 and 3:
select cast(current_timestamp as varchar(30))from rdb$database
results in a string with a different date/time format. At least on
Windows with Firebird 2.5 64-bit.
Dialect 1: 7-DEC-2015 20:29:12.3820
Dialect 3: 2015-12-07 20:31:07.2280
Is this intended?
Thanks.
--
With regards,
Thomas Steinmaurer
http://www.upscene.com/
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
Executing the following in both, dialect 1 and 3:
select cast(current_timestamp as varchar(30))from rdb$database
results in a string with a different date/time format. At least on
Windows with Firebird 2.5 64-bit.
Dialect 1: 7-DEC-2015 20:29:12.3820
Dialect 3: 2015-12-07 20:31:07.2280
Is this intended?
Thanks.
--
With regards,
Thomas Steinmaurer
http://www.upscene.com/
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.