division by date when create table

[乔彦克]

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*