Re: Using make_timestamp() to create a BC value - Mailing list pgsql-general

Bryn Llewellyn <bryn@yugabyte.com> writes:
> But this invocation makes the assertion fail:
> call assert_make_ts_from_extracted_fields_from_ts_ok('0001-01-01 00:00:00 BC');
> The 22008 error is reported thus:
> date field value out of range: -1-01-01

As of v14, make_timestamp[tz] will accept negative year values as
meaning BC.  Before that, they threw errors.

            regards, tom lane