-
Notifications
You must be signed in to change notification settings - Fork 8.3k
TimeZone is ignored in function if with Date and DateTime #24128
Copy link
Copy link
Closed
Labels
bugConfirmed user-visible misbehaviour in official releaseConfirmed user-visible misbehaviour in official releasecomp-datetimeDate/DateTime/TimeZone datatypes and date-time semantics.Date/DateTime/TimeZone datatypes and date-time semantics.
Description
qoega-dev.sas.yp-c.yandex.net :) SELECT toDate('2000-01-01') < toDateTime('2000-01-01 00:00:01', 'Europe/Moscow');
SELECT toDate('2000-01-01') < toDateTime('2000-01-01 00:00:01', 'Europe/Moscow')
Query id: baf63ad5-1893-401c-9728-63bd5c295df1
┌─less(toDate('2000-01-01'), toDateTime('2000-01-01 00:00:01', 'Europe/Moscow'))─┐
│ 0 │
└────────────────────────────────────────────────────────────────────────────────┘
1 rows in set. Elapsed: 0.011 sec.
qoega-dev.sas.yp-c.yandex.net :) SELECT toDate('2000-01-01') < toDateTime('2000-01-01 00:00:01');
SELECT toDate('2000-01-01') < toDateTime('2000-01-01 00:00:01')
Query id: c2136446-a3a0-4567-a94e-68f40dc1f158
┌─less(toDate('2000-01-01'), toDateTime('2000-01-01 00:00:01'))─┐
│ 1 │
└───────────────────────────────────────────────────────────────┘
1 rows in set. Elapsed: 0.011 sec.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
bugConfirmed user-visible misbehaviour in official releaseConfirmed user-visible misbehaviour in official releasecomp-datetimeDate/DateTime/TimeZone datatypes and date-time semantics.Date/DateTime/TimeZone datatypes and date-time semantics.