DEXTRACT
(DEXTRACT(
datetime
))
Returns the date portion of a value that has a DATETIME data type.
In the following example, the value of
vdextract
is
06/12/93
.
SET VAR vdextract = (DEXTRACT('06/12/93 12:15:30.123'))