Different Datetime delimiters gives me different date format

[Tatiana Zadiraka]

Here is what I get from CLP commands

db2 => VALUES date('20-12-2003')
SQL0181N The string representation of a datetime value is out of
range.
SQLSTATE=22007
db2 => VALUES date('20.12.2003')

1
----------
20.12.2003

1 record(s) selected.

db2 => VALUES date('20/12/2003')
SQL0181N The string representation of a datetime value is out of
range.
SQLSTATE=22007
I have ru_RU.CP1251 locale. How to get the same local format for each
date delimiter? In other words I want to get

VALUES date('20-12-2003') = 20-12-2003
VALUES date('20.12.2003') = 20.12.2003
VALUES date('20/12/2003') = 20/12/2003

Thanks in advance,
Tatiana

[Joachim Mueller]

Tatiana,

look for this article about date and times with ISO,DEF LOC etc.
http://www-106.ibm.com/developerwork.../0211yip3.html

regards,
Joachim Müller

"Tatiana Zadiraka" <ta*@aleksin.tula.net> schrieb im Newsbeitrag
news:86*************************@posting.google.co m...

Here is what I get from CLP commands

db2 => VALUES date('20-12-2003')
SQL0181N The string representation of a datetime value is out of
range.
SQLSTATE=22007
db2 => VALUES date('20.12.2003')

1
----------
20.12.2003

1 record(s) selected.

db2 => VALUES date('20/12/2003')
SQL0181N The string representation of a datetime value is out of
range.
SQLSTATE=22007
I have ru_RU.CP1251 locale. How to get the same local format for each
date delimiter? In other words I want to get

VALUES date('20-12-2003') = 20-12-2003
VALUES date('20.12.2003') = 20.12.2003
VALUES date('20/12/2003') = 20/12/2003

Thanks in advance,
Tatiana