Re: to_date() and to_timestamp() with negative years

On 11/3/21 17:00, Adrian Klaver wrote:
> On 11/3/21 15:56, Bryn Llewellyn wrote:
>>> tgl(at)sss(dot)pgh(dot)pa(dot)us wrote:
>>>

>> And you have to have some kind of separator between the years
>> substring and the adjacent one(s) even to succeed with years that have
>> more than four digits. Another usage note stresses that while this is OK:
>>
>> select to_date('12340101', 'YYYYMMDD');
>>
>> this isn't:
>>
>> select to_date('123450101', 'YYYYMMDD');
>
> It does with a tweak:
>
> select to_date('12345 0101', 'FMYYYYMMDD');
>    to_date
> -------------
>  12345-01-01

Well that was just plain wrong. I was not paying attention.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com