Re: Standard-conforming datetime years parsing

From: Vik Fearing <vik(dot)fearing(at)2ndquadrant(dot)com>
To: Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Standard-conforming datetime years parsing
Date: 2019-11-05 18:32:09
Message-ID: 017b81fb-0cf9-5a5f-11f6-0002f0b36b98@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 05/11/2019 02:45, Alexander Korotkov wrote:
> 3) Do we like to change behavior to_date()/to_timestamp()? Or just
> jsonpath .datetime() and future CAST(... AS ... FORMAT ...) defined in
> SQL 2016?

I don't want to hijack this thread, but I would like the CAST feature to
call to_timestamp() and to_char(), even if they aren't 100% standard
compliant today.

I see a new column on pg_cast where users can define the function to do
the cast with format.

--

Vik

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2019-11-05 18:41:28 Re: Include RELKIND_TOASTVALUE in get_relkind_objtype
Previous Message Andrey Lepikhov 2019-11-05 18:20:28 Re: Removing unneeded self joins