Repository navigation
[EPIC] Additional Date/Time related open issues #8282
Description
This is a follow on ticket to #3148 given we have closed so many of the previous items it is hard to see what is still left to do
Please edit the list or comment bellow if you find something not listed here.
Documentation
Date/Time/Timestamp Types & Casting
- Support to_timestamp with 2 arguments (timestamp format) #5398
- Support
floatarguments toto_timestampfunction #7868 - Timestamp overflows for extreme low/high values #8336
- Minor: small refactoring for ints/floats to timestamps conversions #8370
- select interval '1 YEAR' error #8465
- Discussion: handling comparison of intervals #8468
- Support "standard" / alternate format arguments for
to_timestamp#8915
TimestampTz Date Types & Casting & Coercion
Intervals
Arithmetic (including intervals)
- Support binary temporal coercion for Date64 and Timestamp types #8275
- support: Date +/plus Int or date_add function #6876
Functions
- The return type of EXTRACT #1992
- Specific timezone support for
to_timetamp*()#686 - change
extractreturn types to decimal to align with postgres #3996 - Implement
to_unixtimefunction #5568 - support make_interval function #6951
- Add a make_date function #9024
- Implement date/time -> string formatting functions #9147
Activity
comphead commentedon Nov 21, 2023
oh wow, thanks @alamb
alamb commentedon Jan 27, 2024
FYI @Omega359 in case you are interested in other things we have identified
alamb commentedon May 2, 2024
Added #10344 to document the semantics of timezones