[jira] [Created] (CALCITE-5629) In TimestampString, allow negative years and years with more than 4 digits

["Julian Hyde (Jira)" <ji...@apache.org>]

Julian Hyde created CALCITE-5629:
------------------------------------

             Summary: In TimestampString, allow negative years and years with more than 4 digits
                 Key: CALCITE-5629
                 URL: https://issues.apache.org/jira/browse/CALCITE-5629
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde


In {{TimestampString}}, allow negative years, and years with more than 4 digits.

Per [ISO 8601|https://en.wikipedia.org/wiki/ISO_8601#Years], 0000 means 1 BC, -0001 means 2 BC, etc.

In the canonical form, years will have at least 4 digits. If they have more than 4 digits they must not start with zero.

The implementation should be sure to test conversion of negative timestamp values to and from {{java.util.Calendar}} (which probably represents BC dates using {{Calendar.ERA}} field). {{TimestampString}} currently assumes that digits 0..3 are year, 5..6 are month, etc., and the point is at position 20, so many functions will need to be re-tested.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)