DEXTRACT
Top  Previous  Next

(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'))