MDY4/
01/20/2017
DMY2-
20-01-17
MDY4
01/20/2017
Y2DM.
17.20.01
MDY20
012017
Y4MD*
2017/01/20
Specifies the end-user format for DATE values.
Syntax:
DBDATE=<sequence of characters>
Possible values:
|
D |
= day |
|
M |
= month |
|
Y2, Y4 |
= year (the figure shows the year display format) |
|
-./ |
characters that can be used as a separator in the date format |
|
0 |
no separator is to be displayed between the units |
Usage and examples:
DBDATE effects how DATE values are interpreted at input and displayed and output:
DBDATE=MDY4/
DBDATE value defines how these attributes of the date format are displayed on the client side:
§ separator between the time unit,
§ display format of the year – by two or four digits,
§ order of time units in a date.
|
MDY4/ |
|
01/20/2017 |
|
DMY2- |
|
20-01-17 |
|
MDY4 |
|
01/20/2017 |
|
Y2DM. |
|
17.20.01 |
|
MDY20 |
|
012017 |
|
Y4MD* |
|
2017/01/20 |
If the separator character is absent (MDY4) or not valid (Y4MD*), the default separator - / (slash) - is displayed.
DBDATE applies at runtime, so it must be set in inet.env.
Related articles: