Sign in
apache
/
drill-test-framework
/
9a5d7ecf7f32f0e95c0ea874e75d785fdee9e51d
/
.
/
framework
/
resources
/
Functional
/
aggregates
/
aggregation
/
group_by_expression
/
extract_month_from_timestamp_with_cast.sql
blob: f9eddfbf426264ef92e5c18d1df486e4fe7b78cb [
file
] [
log
] [
blame
]
select
cast
(
extract
(
month
from
c_timestamp
)
as
bigint
)
from
alltypes
group
by
cast
(
extract
(
month
from
c_timestamp
)
as
bigint
)
order
by
cast
(
extract
(
month
from
c_timestamp
)
as
bigint
);