Scalar. Truncates the time portion of a date to 00:00:00 and returns the new date value.
trunc ( datevalue )
| datevalue | A date or bigdatetime. |
Truncates the time portion of a date value to 00:00:00 and returns the new date value. The function takes a date or bigdatetime as its argument, and the function returns the same datatype.
trunc (undate ('2001:05:23 12:34:64')) returns 2001:05:23 00:00:00.