Subject RE: [firebird-support] Re: Problems selecting on Timestamp.
Author MacauIT Career
hi
To: firebird-support@yahoogroups.com
From: aharrison@...
Date: Wed, 9 Nov 2011 11:20:44 -0500
Subject: Re: [firebird-support] Re: Problems selecting on Timestamp.




























Helen Borrie <helebor@...> wrote:



>

> >Technically it is locale-dependent conversion as well.

>



True for PostgreSQL, but not Firebird.



>

> Technically it's not. It's not locale-dependent and it's not (in most

> contexts) a conversion but encoding of recognised literal formats. The fact

> that it uses English abbreviations for calendar months is not due to locale

> but to a xenophobic implementation.

>



Probably deep in the bowels there are the remains of a translation facility

which at one point included a database that stored the translations of

literals, common strings (like month names), and error messages. However,

it never handled other calendars, so if you want to go all Mayan and end

the world next year, you're out of luck.



Ann



[Non-text portions of this message have been removed]



















[Non-text portions of this message have been removed]