SET DATEMASK

Change SQL Datemask

This directive changes the SQL date format for this task.

Syntax

SET DATEMASK string-value [,ERR=line-ref|,ERC=error-code]

string-value: is any string that represents a valid SQL datemask.
line-ref: is the program line number or label to branch to if an error is produced.
error-code: is a programmer-defined error code. Valid values are positive or negative whole numbers.

This directive is generally available starting with release level 8.2.

Specifying a null SQL datemask (i.e. length = 0), re-loads the default SQL datemask.

Attempting to specify a datemask that has non-printable characters results in an ERR=17.

The assigned mask is the default mask for the NTD( ) and DTN( ) functions.

SET DATEMASK D$

If D$=“DD-Mon-YYYY”, the SQL datemask is changed to the value of D$.

SET DATEMASK "Month DD, YYYY HH:MI PM"

changes the SQL datemask to “Month DD, YYYY HH:MI PM”.

SET DATEMASK " "

reloads the default SQL datemask.