date()

Scalar. Converts a date value into an integer with the digits YYYYMMDD.

Syntax

date ( datevalue )

Parameters

datevalue

A date

Usage

The function returns an integer.

Example

date (undate ('1991-04-01 12:43:32')) returns 19910401.