skip to main content
DataDirect Connect Drivers : Informix Driver : Connection Properties : DBDate
  
DBDate
Purpose
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.
Valid Values
DMY2[sep_character] | DMY4[sep_character] |
MDY2[sep_character] | MDY4[sep_character] |
Y4DM[sep_character] | Y4MD[sep_character] |
Y2DM[sep_character]
where:
D
is a 2-digit day field.
M
is a 2-digit month field.
Y2
is a 2-digit year field.
Y4
is a 4-digit year field.
sep_character
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).
Default
None
Data Type
String