create table ocean_buoys(buoyid integer, salinity integer, temperature integer) PRIMARY TIME INDEX(TIMESTAMP(6), DATE '2016-04-19', HOURS(1)); -- The following two adjcent SELECT statements should return the same output: SELECT td_gettimebucket(td_timecode) from ocean_buoys; SELECT td_gettimebucket(ocean_buoys.td_timecode) from ocean_buoys; TD_GETTIMEBUCKET(TD_TIMECODE) ----------------------------- 289 -- The column title contains TIMEBUCKET_COL. SELECT td_gettimebucket(ocean_buoys.td_timecode) as TimeBucket_COL from ocean_buoys; TIMEBUCKET_COL -------------- 289 SELECT buoyid FROM ocean_buoys WHERE td_gettimebucket(td_timecode) > 200; BUOYID ------ 101