Enter Dates

The set dateformat command specifies the order of the date parts (month, day, and year) when dates are entered as strings of numbers with separators.

set language can also affect the format for dates, depending on the default date format for the language you specify. The default language is us_english, and the default date format is mdy. See the Reference Manual: Commands.

Note: dateformat affects only the dates entered as numbers with separators, such as “4/15/90” or “20.05.88”. It does not affect dates where the month is provided in alphabetic format, such as “April 15, 1990” or where there are no separators, such as “19890415”.

Date Formats
SAP ASE recognizes three basic date formats. Each format must be enclosed in quotes and can be preceded or followed by a time specification.

Parent topic: Date and Time