Re: [Firebird-devel] LOCALTIMESTAMP name

2018-10-23 Thread Lester Caine
On 23/10/2018 15:43, Adriano dos Santos Fernandes wrote: AFAIK, but I may be wrong, "TIMESTAMP" is not a correct single word too. There has been a similar debate over TIME ZONE and the RFC for tzdist specifically adopted TIMEZONE to get around the need for an underscore. TIMESTAMP became the

Re: [Firebird-devel] LOCALTIMESTAMP name

2018-10-23 Thread Mark Rotteveel
On 23-10-2018 16:43, Adriano dos Santos Fernandes wrote: AFAIK, but I may be wrong, "TIMESTAMP" is not a correct single word too. :) Well: https://dictionary.cambridge.org/us/dictionary/english/timestamp (although other dictionaries only list time stamp) It seems in English, use of time stam

Re: [Firebird-devel] LOCALTIMESTAMP name

2018-10-23 Thread Adriano dos Santos Fernandes
On 23/10/2018 11:36, Mark Rotteveel wrote: > On 23-10-2018 16:20, liviuslivius wrote: >> Really strange "standard" here... > > Standards are nothing but inconsistent, especially as they evolve over > time. However, CURRENT_TIME dates back to at least the SQL:92 standard > (and probably existed earl

Re: [Firebird-devel] LOCALTIMESTAMP name

2018-10-23 Thread Mark Rotteveel
On 23-10-2018 16:20, liviuslivius wrote: Really strange "standard" here... Standards are nothing but inconsistent, especially as they evolve over time. However, CURRENT_TIME dates back to at least the SQL:92 standard (and probably existed earlier in some form in non-standardized dialects), w

Re: [Firebird-devel] LOCALTIMESTAMP name

2018-10-23 Thread liviuslivius
Really strange "standard" here...Thank youRegards,Karol Bieniaszewski nullFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] LOCALTIMESTAMP name

2018-10-23 Thread Mark Rotteveel
On 23-10-2018 11:36, liviuslivius wrote: Hi, why "LOCALTIMESTAMP" not "LOCAL_TIMESTAMP" as is for e.g. "CURRENT_TIMESTAMP"? That is because SQL:2016, ISO 9075-2:2016, in section 6.36 value function>, specifies the names as CURRENT_TIME, CURRENT_TIMESTAMP and LOCALTIME and LOCALTIMESTAMP . M

Re: [Firebird-devel] LOCALTIMESTAMP name

2018-10-23 Thread Dimitry Sibiryakov
23.10.2018 11:36, liviuslivius wrote: why "LOCALTIMESTAMP" not "LOCAL_TIMESTAMP" as is for e.g. "CURRENT_TIMESTAMP"? SQL standard. -- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] LOCALTIMESTAMP name

2018-10-23 Thread liviuslivius
Hi,   why "LOCALTIMESTAMP" not "LOCAL_TIMESTAMP" as is for e.g. "CURRENT_TIMESTAMP"?   regards, Karol BieniaszewskiFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel