Thank you Suresh, I read the page and have more understanding about division.
Suresh Subbiah <[email protected]>于2016年8月16日周二 下午10:30写道： > Hi, > > Please look at this page > https://cwiki.apache.org/confluence/display/TRAFODION/Cmp-divisioning > > I think the syntax you are looking for is *division by (date_trunc('day', > ts));* > > Thank you > Suresh > > On Tue, Aug 16, 2016 at 2:44 AM, 乔彦克 <[email protected]> wrote: > >> Hi,all, >> Since Trafodion has the feature 'division by' and I have the need for >> date query, so when create table >> I want to division by the date (eg '2016-07-01'), but I cannot find a >> good way to do so. >> The 'cast' method cannot be used in the division by, and date_part only >> get the 'year' attribute. >> * Can anyone help me with that or give me more detail info about >> 'division by'?* >> >> Any reply is appreciated, Thanks. >> >> *Qiao Yanke* >> >> >
