date_order option

MDY, YMD, DMY

YMD (this corresponds to ISO date format specifications)

For Sybase Open Client and jConnect connections, the default is set to MDY

Can be set for an individual connection or for PUBLIC. You must have the SET ANY PUBLIC OPTION system privilege to set this option for PUBLIC or for another user or role. Takes effect immediately.

The database option date_order is used to determine whether 10/11/12 is Oct 11 1912, Nov 12 1910, or Nov 10 1912.

Note

If you change the setting for date_order in a way that re-orders the date format, to change the date_format and timestamp_format options to reflect the same change, and vice versa. See date_format option, and timestamp_format option.

date_order option

Allowed values

Default

Scope

Remarks

Note

See also