DBDATE
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 |
DBDATE applies at runtime, so it is set in inet.env.
Related articles