Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
datetime
/
datetime191.q
blob: afaa07b2d5d78d8d3d83c8f9059ae1a6c3333566 [
file
] [
log
] [
blame
]
select
max
(
cast
(
c_time
as
time
))
as
col1
,
cast
(
c_time
as
time
)
+
(
interval
'2:30:45.100'
hour to second
*
(
10
/
2
))
as
col2
from
basic
group
by
cast
(
c_time
as
time
)
+
(
interval
'2:30:45.100'
hour to second
*
(
10
/
2
))
order
by
col1
;