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*
>
>
