> On 8-12-2015 09:52, Thomas Steinmaurer [email protected] > [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 >> 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? > > It is intended, the dialect 3 format conforms to the SQL standard to > always use ISO-8601 format, while dialect 1 preserves backwards > compatibility by using a locale specific conversion. > > See also http://ibphoenix.com/resources/documents/design/doc_169
Thanks Mark. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
