-
Notifications
You must be signed in to change notification settings - Fork 1.8k
Closed
Description
This is followed on the Proposal for Date/Time enhancement #3100
Please edit the list or comment bellow if you find something not listed here.
Date/Time/Timestamp Types & Casting
- Add support for
TIMEliteral values #2883 - This is the initial work forTIMEliteral (i.e. makeSELECT TIME '00:00:00';work) - Casting between timestamp types should use scalar multiply/divide kernels arrow-rs#2074 - This is to improve the performance of casting timestamp between different unit
- [Datafusion] Error with CAST: Unsupported SQL type Time #193 - This depends on Add support for
TIMEliteral values #2883 - Cast string to timestamp crash while we input time before 1970 with floating number second #3082
- Support to_timestamp with 2 arguments (timestamp format) #5398
- Support
floatarguments toto_timestampfunction #7868 -
date_truncalways returnsTimestamp(Nanosecond, None)which might truncate ranges #6653 -
date_trunc(null)results in a panic #6701 - Incorrect results for negative intervals #6720
TimestampTz Date Types & Casting & Coercion
- Can not create a TimestampNanosecondArray that has a specified timezone arrow-rs#597
- Format timestamps that have a timezone using RFC339 format arrow-rs#599
- Implement FromIter for timestamps, that includes timezone info arrow-rs#168
- Querying datetime data in DataFusion with an embedded timezone always fails #153
- Should
Cast(UTF-8 AS Timestamp)apply local time zone? #3080 - SELECT ... ORDER BY query fails on data with int64 timestamp and timezone field #959
- cast to timestamp with time zone drops timezone #3149
- Add Time Zone support datafusion-sqlparser-rs#588
- Not possible to have timezone in postgres datafusion-sqlparser-rs#464
- Add TIMESTAMPTZ #3659
- convert string to timestamp shouldn't apply local timezone offset if there's no explicit timezone info in the string arrow-rs#2813
- Support SQLDataType::Timestamp(TimezoneInfo) #3693
-
Time With Time Zoneshould raise error untilDataType::Time64support tz #3715 - Add timezone abstraction arrow-rs#2909
- support
[+/-]hhmmand[+/-]hhas fixedoffset timezone format arrow-rs#2910 - Cast Kernel Ignores Timezone arrow-rs#1936
- Support for type coercion for a (Timestamp, Utf8) pair #4311
- Interval coercion:
date_bin('1 hour',...)does not work butdate_bin(interval '1 hour', ...does #4853 - Supporting casts to timestamptz: Eq Utf8 of binary physical should be same" #5164
-
try_cast_literal_to_typedoesn't respect timestamp precision #5507 - Special case Duration display in datafusion-cli and sqllogictest #7070
- date_bin cannot use a string origin parameter when the expression has a time zone. #7697
Intervals
See #5753
Arithmetic (including intervals)
- Add support for AVG(Timestamp) types #200
- Add support for subtracting timestamps --> intervals #194
- feat: support Timestamp +/- Interval #3103
- Interval plus(+) Timestamp operation support #5413
- functions in temporal_conversions do not handle negative integers correctly arrow-rs#593
- Add temporal kernels for arithmetic with timestamps and durations arrow-rs#527
- Interval is out of spec arrow-rs#187
- Support Time64/Time32 comparison arrow-rs#2457 - arrow-rs
- Support Time comparison #3157 - datafusion
- Support
SUMAVG,MIN,MAXonTimecolumns. #3166 - Interval Literal output inconsistent date_type #3180
- Incorrect Numeric operations on MONTH_DAY_NANO interval type arrow-rs#1065
- Interval Literal doesn't work for timeunit less than millisecond #3204
- Incorrect error for plus/minus operations over timestamps and dates #4420
- Comparing a
Timestampto aDate32fails #4644 - Timestamp Subtraction #5411
-
timestamp- interval results inThe type of Timestamp(Nanosecond, Some("+00:00")) Minus Utf8 of binary physical should be same#5650 - Timestamp and Interval arithmetics #5704
- support make_interval function #6951
- Use
Durationas the result oftimestamp - timestamprather thanInterval#7068 - Support binary temporal coercion for Date64 and Timestamp types #8275
Functions
-
date_partdoes't work fornow()#3096 - once now() is called in a statement, it forever returns the same value #3057
- to_timestamp timeunit to be consistent with postgresql's #2979
- The return type of EXTRACT #1992
- Predicates on to_timestamp do not work as expected with "naive" timestamp strings #765
- Specific timezone support for
to_timetamp*()#686 - Handle the timezone in extract week in temporal.rs arrow-rs#1380
- Predicates on to_timestamp do not work as expected with "naive" timestamp strings #765
- Paniced at to_timestamp_micros function when the timestamp is too large. #3832
- replace
from_timestampbyfrom_timestamp_optarrow-rs#2892 - Can not use
extract <part>on the value ofnow()#3980 - Implement
current_dateFunction #3981 - Implement
current_timeFunction #3982 - change
extractreturn types to decimal to align with postgres #3996 - change
date_partreturn types to f64 #3997 - support keyword
NANOSECONDdatafusion-sqlparser-rs#748 - Extract from timestamp doesn't support nanosecond #4528
- EXTRACT(EPOCH from column) #2785
- Support
date_binwith 2 arguments (rather than requiring three) #5641 - Implement
to_unixtimefunction #5568 - support: Date +/plus Int or date_add function #6876
- Timestamp with timezone cannot be supported by GROUP BY #7604
parquet/csv/json
- Reading Parquet file with timestamp column with
9999year results in overflow panic arrow-rs#982 - Parquet Scan Filter arrow-rs#1191
- csv reader does not detect ISO date strings as timestamps arrow-rs#1060
- Not able to read nano-second timestamp columns in 1.0 parquet files written by pyarrow arrow-rs#455
- Read temporal values from JSON arrow-rs#38
- wrong result when operation parquet #2044
- Cannot import Time64 from CSV #3176
others
watfordkcf, jiacai2050 and friendlymatthew
Metadata
Metadata
Assignees
Labels
No labels