DATEFORMAT

The DATEFORMAT parameter specifies the order of the date components (month/day/year) when date-time values are entered in the formatted string and translated string formats. It makes the input format of a value independent of the format of the variable to which it is being assigned.

The syntax is:

SET DATEFORMAT = datefmt

where:

datefmt

Can be one of the following: MDY, DMY, YMD, or MYD. MDY is the default value for the U.S. English format.

Did you find this helpful?

Yes No