Home > mailing lists

date function bug - Mailing list pgsql-general

From	Abraham, Danny
Subject	date function bug
Date	October 23, 2019 17:22:31
Msg-id	0bac35bcde6747e485bc7468c4080798@phx-exmbprd-01.adprod.bmc.com Whole thread Raw
Responses	Re: date function bug Re: date function bug Re: date function bug Re: date function bug
List	pgsql-general

Tree view

Hi,

The function "to_date" does not fail illegal values.
Is this a known bug?
What is the recommended type checking?


ctrlmdb=> select to_date('2018100X','YYYYMMDD');
  to_date
------------
 2018-10-01
(1 row)

pgsql-general by date:

From: Laurenz Albe
Date: 23 October 2019, 14:42:47
Subject: Re: jsonb_set() strictness considered harmful to data

From: Ravi Krishna
Date: 23 October 2019, 17:28:15
Subject: Re: date function bug

date function bug - Mailing list pgsql-general

Previous

Next