1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
|
# name: test/sql/cast/timestamp_date_cast.test
# description: Issue #2588: Incorrect result with date conversion
# group: [cast]
statement ok
PRAGMA enable_verification
statement ok
create table test as
select '2021-02-04 19:30:00'::timestamp t;
query I
select *
from test
where (t::date) = '2021-02-04'::date;
----
2021-02-04 19:30:00
query I
select *
from test
where (t::date) = '2021-02-04';
----
2021-02-04 19:30:00
# Check that casts to DATE are not invertible
foreach source TIMESTAMP TIMESTAMP_S TIMESTAMP_MS TIMESTAMP_NS
query I
WITH t AS (
SELECT
'2020-09-13 00:30:00'::${source} AS a,
)
SELECT
a::DATE = '2020-09-13'::DATE,
FROM t;
----
true
endloop
|
