Scalar. Converts a date value into an integer with the digits YYYYMMDD.
date ( datevalue )
A date.
The function returns an integer.
date (undate ('1991-04-01 12:43:32')) returns 19910401.