Re: Possibly misleading documentation of Template Patterns for Date/Time Formatting

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Kubecka <davidkubecka366(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Possibly misleading documentation of Template Patterns for Date/Time Formatting
Date: 2020-04-19 13:42:15
Message-ID: 26842.1587303735@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

David Kubecka <davidkubecka366(at)gmail(dot)com> writes:
> Anyway, could you shed some light if there's any particular reason why TO_DATE(
> '2012-4', 'YYYY-Q' ) isn't supported?

You can't compute a specific date from that. Nor does it lend itself to
combination with other fields to reach a specific date --- adding DD
doesn't do it, and if you add MM, you might as well not bother with Q.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Hritik Gupta 2020-04-19 15:39:20 Re: BUG #16373: Behavior of Temporary table creation
Previous Message David Kubecka 2020-04-19 08:19:19 Re: Possibly misleading documentation of Template Patterns for Date/Time Formatting