Summary
Currently, there is some textification support for precisiontimestamp, and some parser support for timestamps, but it doesn't look like there's full bidirectional support for all 3-5 types (Note: names are case-insensitive):
precision_time<P>precision_timestamp<P>precision_timestamp_tz<P>- (deprecated)
timestamp
- (deprecated)
timestamp_tz
We should probably support all 5 as long as they are in the official grammar, with tests to ensure that they can be both parsed and textified.
Stretch
Ideally, we could also have an --upgrade or --fix option, which would automatically convert from timestamp to precision_timestamp and same for _tz. That would be neat.
Summary
Currently, there is some textification support for precisiontimestamp, and some parser support for timestamps, but it doesn't look like there's full bidirectional support for all 3-5 types (Note: names are case-insensitive):
precision_time<P>precision_timestamp<P>precision_timestamp_tz<P>timestamptimestamp_tzWe should probably support all 5 as long as they are in the official grammar, with tests to ensure that they can be both parsed and textified.
Stretch
Ideally, we could also have an
--upgradeor--fixoption, which would automatically convert fromtimestamptoprecision_timestampand same for_tz. That would be neat.