You can use Time, DateTime, and Duration properties for these
Analytics operations:
TRUNC and
EXTRACT.
TRUNC rounds a DateTime down to a coarser
granularity bucket.
EXTRACT extracts a portion of a DateTime, such as
the day of the week.
In addition to these special-purpose functions, Date and Time values can
support arithmetic operations if you cast double or integer fields to a
Duration using
TO_DURATION. For example:
A Duration may be added to a
Time or a DateTime to obtain a new Time or DateTime.
Two Times or two DateTimes
may be subtracted to obtain a Duration.
Two Durations may be added
or subtracted to obtain a new Duration.
