Sets the Informix DBDate server option for formatting literal date values when inserting, updating, and retrieving data in DATE columns. Using this property, you can customize the following items:
Order in which the month, day, and year fields appear in a date string
Year field to contain two or four digits
Separator character used to separate the date fields
This property does not affect the format of the string in the date escape syntax. Dates specified using the date escape syntax always use the JDBC escape format: yyyy-mm-dd.
is one of the following characters used to separate the fields: hyphen (-), period (.), or forward slash (/). If a separator is not specified, a forward slash (/) is used to separate the fields.
If unspecified, the format of literal date values conforms to the default server behavior.
Example
A value of Y4MD- specifies a date format that has a 4-digit year, followed by the month and then by the day. The date fields are separated by a hyphen (-) (for example: 2004-02-15).