Postgres Pro
Downloads
Home   >   mailing lists

رد: BUG #16419: wrong parsing BC year in to_date() function - Mailing list pgsql-bugs

From دار الآثار للنشر والتوزيع-صنعاء Dar Alathar-Yemen
Subject رد: BUG #16419: wrong parsing BC year in to_date() function
Date
Msg-id AM0PR03MB3570F55B3943E5DF84C7F08EBFA50@AM0PR03MB3570.eurprd03.prod.outlook.com
Whole thread Raw
In response to Re: BUG #16419: wrong parsing BC year in to_date() function  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Tree view

 

 

research how it behaves in the other database it tries to emulate and either document or possibly change the behavior in v14

As in https://stackoverflow.com/questions/6779521/how-do-i-insert-a-bc-date-into-oracle and http://rwijk.blogspot.com/2008/10/year-zero.html

In Oracle 

to_date('-4700/01/01','syyyy/mm/dd')

returns 

01/01/4700 BC

In documents https://docs.oracle.com/cd/B28359_01/olap.111/b28126/dml_commands_1029.htm#OLADM780

YEAR
SYEAR

 

Year, spelled out; S prefixes BC dates with a minus sign (-).

YYYY
SYYYY

 

4-digit year; S prefixes BC dates with a minus sign.

 

 

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #16421: Table Rapid Growth due to tuple accumulation
Next
From: PG Bug reporting form
Date:
Subject: BUG #16422: psqlodbc