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;