Sign in
apache
/
drill-test-framework
/
0c85b4fdd97d4bceb9f295eb434983b210bff100
/
.
/
framework
/
resources
/
Functional
/
joins
/
explicit_cast
/
on_c_timestamp_and_c_date.sql
blob: 446357d029adc045d44b2900a1a66c4997c956da [
file
] [
log
] [
blame
]
select
count
(*)
from
cast_tbl_1 a
INNER
JOIN
cast_tbl_2 b
ON
(
a
.
c_integer
=
b
.
c_integer
)
where
CAST
(
a
.
c_timestamp
AS
DATE
)
<>
b
.
c_date
;