On 01/09/2018 01:57 PM, Pavel Stehule wrote:
>
>
> 2018-01-09 19:52 GMT+01:00 Andrew Dunstan
> mailto:andrew.duns...@2ndquadrant.com>>:
>
>
>
> On 01/09/2018 01:46 PM, Pavel Stehule wrote:
> >
> >
> > I checked this patch and I think so it is correct.
> >
> > 1. all tests
2018-01-09 19:52 GMT+01:00 Andrew Dunstan :
>
>
> On 01/09/2018 01:46 PM, Pavel Stehule wrote:
> >
> >
> > I checked this patch and I think so it is correct.
> >
> > 1. all tests passed
> > 2. no problems with patching and compilation
> > 3. the doc is good enough
> > 4. I can confirm so Oracle 12
On 01/09/2018 01:46 PM, Pavel Stehule wrote:
>
>
> I checked this patch and I think so it is correct.
>
> 1. all tests passed
> 2. no problems with patching and compilation
> 3. the doc is good enough
> 4. I can confirm so Oracle 12c supports these formats, but I have not
> possibility to test it
2018-01-09 19:46 GMT+01:00 Pavel Stehule :
> Hi
>
> 2018-01-08 1:22 GMT+01:00 Nikita Glukhov :
>
>> On 03.01.2018 21:34, Tom Lane wrote:
>>
>> Andrew Dunstan writes:
>>>
This small and simple standalone patch extracted from the SQL/JSON work
would allow the user to supply a string with
Hi
2018-01-08 1:22 GMT+01:00 Nikita Glukhov :
> On 03.01.2018 21:34, Tom Lane wrote:
>
> Andrew Dunstan writes:
>>
>>> This small and simple standalone patch extracted from the SQL/JSON work
>>> would allow the user to supply a string with a time zone specified as
>>> hh:mm thus:
>>> SELECT
On 03.01.2018 21:34, Tom Lane wrote:
Andrew Dunstan writes:
This small and simple standalone patch extracted from the SQL/JSON work
would allow the user to supply a string with a time zone specified as
hh:mm thus:
SELECT to_timestamp('2011-12-18 11:38 -05:20', '-MM-DD HH12:MI
TZH
On 01/03/2018 02:21 PM, Andrew Dunstan wrote:
>
> On 01/03/2018 01:34 PM, Tom Lane wrote:
>> Andrew Dunstan writes:
>>> This small and simple standalone patch extracted from the SQL/JSON work
>>> would allow the user to supply a string with a time zone specified as
>>> hh:mm thus:
>>> SELECT
Vik Fearing writes:
> On 01/03/2018 08:39 PM, Tom Lane wrote:
>> Vik Fearing writes:
>>> Shouldn't this support TZS or something for seconds?
>> According to the docs I cited upthread, there's no such field type
>> in Oracle.
> So what?
Well, the function is meant to be Oracle-compatible, so w
On 01/03/2018 08:39 PM, Tom Lane wrote:
> Vik Fearing writes:
>> Shouldn't this support TZS or something for seconds?
>
> According to the docs I cited upthread, there's no such field type
> in Oracle.
So what?
--
Vik Fearing +33 6 46 75 15 36
http://2ndQ
Vik Fearing writes:
> Shouldn't this support TZS or something for seconds?
According to the docs I cited upthread, there's no such field type
in Oracle.
regards, tom lane
On 01/03/2018 07:03 PM, Andrew Dunstan wrote:
>
> This small and simple standalone patch extracted from the SQL/JSON work
> would allow the user to supply a string with a time zone specified as
> hh:mm thus:
>
>
> SELECT to_timestamp('2011-12-18 11:38 -05:20', '-MM-DD HH12:MI
> TZH:T
Andrew Dunstan writes:
> On 01/03/2018 01:34 PM, Tom Lane wrote:
>> BTW, I had not known this before, but according to the page I'm
>> looking at
>> https://docs.oracle.com/database/121/SQLRF/sql_elements004.htm#SQLRF00212
>> Oracle also supports "TZD" to mean a time zone abbreviation (their
>> ex
On 01/03/2018 01:34 PM, Tom Lane wrote:
> Andrew Dunstan writes:
>> This small and simple standalone patch extracted from the SQL/JSON work
>> would allow the user to supply a string with a time zone specified as
>> hh:mm thus:
>> SELECT to_timestamp('2011-12-18 11:38 -05:20', '-MM-DD HH
Andrew Dunstan writes:
> This small and simple standalone patch extracted from the SQL/JSON work
> would allow the user to supply a string with a time zone specified as
> hh:mm thus:
> SELECT to_timestamp('2011-12-18 11:38 -05:20', '-MM-DD HH12:MI
> TZH:TZM');
> to_timest
This small and simple standalone patch extracted from the SQL/JSON work
would allow the user to supply a string with a time zone specified as
hh:mm thus:
SELECT to_timestamp('2011-12-18 11:38 -05:20', '-MM-DD HH12:MI
TZH:TZM');
to_timestamp
--
15 matches
Mail list logo
