[firebird-support] Dialect 1 vs. 3: DATE to VARCHAR CAST results in different date/time format

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

Re: [firebird-support] Dialect 1 vs. 3: DATE to VARCHAR CAST results in different date/time format

On 8-12-2015 09:52, Thomas Steinmaurer t...@iblogmanager.com [firebird-support] wrote: > 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 > Window

Re: [firebird-support] Dialect 1 vs. 3: DATE to VARCHAR CAST results in different date/time format

> On 8-12-2015 09:52, Thomas Steinmaurer t...@iblogmanager.com > [firebird-support] wrote: >> 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