Question on cast string to date

From: 正华吕 <kainwen(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Question on cast string to date
Date: 2022-05-10 04:28:35
Message-ID: CANerzAcbEw0Uvv9APGK4FORGbeJ0ftwtuG6=kNgA_P0NTxa9ew@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I test the following SQL in pg15dev (seems same behavior as the
previous version).

select '2020701'::date;
date
------------
0202-07-01
(1 row)

At the first glance, the result seems quite strange.

Go through the code, postgres use date_in to do the cast, and firstly
use last 2 chars to
get the day, and the 2 chars to get the month, and all remaining chars
as year.

The question here is: should we throw error for such input? Or what
standard postgres is
using to cast such kind of string?

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2022-05-10 04:36:08 Re: Question on cast string to date
Previous Message Bharath Rupireddy 2022-05-10 03:56:47 Re: Set timeout just on a query?