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)