TO_DATE function returns undesirable format [message #292307] |
Tue, 08 January 2008 09:02  |
trivendra
Messages: 211 Registered: October 2007 Location: Phoenix
|
Senior Member |
|
|
Hi,
I have problem with to_date function which return unexpected format when we 'DD-MM-YYYY' with to_date
Why it gives 0008 when used in first query, given below
SQL> SELECT TO_CHAR(TO_DATE(SYSDATE,'DD-MM-YYYY'),'DD-MM-YYYY') FROM DUAL;
TO_CHAR(TO_DATE(SYSDATE,'DD-MM
------------------------------
08-01-0008
SQL> SELECT TO_CHAR(TO_DATE(SYSDATE,'DD-MM-YY'),'DD-MM-YYYY') FROM DUAL;
TO_CHAR(TO_DATE(SYSDATE,'DD-MM
------------------------------
08-01-2008
SQL> SELECT TO_CHAR(TO_DATE(SYSDATE,'DD-MM-RR'),'DD-MM-YYYY') FROM DUAL;
TO_CHAR(TO_DATE(SYSDATE,'DD-MM
------------------------------
08-01-2008
SQL> SELECT TO_CHAR(TO_DATE(SYSDATE,'DD-MM-RRRR'),'DD-MM-YYYY') FROM DUAL;
TO_CHAR(TO_DATE(SYSDATE,'DD-MM
------------------------------
08-01-2008
Thanks
Trivendra
[Updated on: Tue, 08 January 2008 09:11] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|
|
|
Re: TO_DATE function returns undesirable format [message #292320 is a reply to message #292307] |
Tue, 08 January 2008 09:31   |
trivendra
Messages: 211 Registered: October 2007 Location: Phoenix
|
Senior Member |
|
|
Hi Michel,
What if it is not sysdate.
SQL> SELECT TO_CHAR(TO_DATE('01-01-2008','DD-MM-YYYY'),'DD-MM-YYYY') FROM DUAL;
TO_CHAR(TO_DATE('01-01-2008','
------------------------------
01-01-2008
SQL> SELECT TO_CHAR(TO_DATE(TO_DATE('01-01-2008','DD-MM-YYYY'),'DD-MM-YYYY'),'DD-MM-YYYY') FROM DUAL;
TO_CHAR(TO_DATE(TO_DATE('01-01
------------------------------
01-01-0008
SQL> SELECT TO_CHAR(TO_DATE(TO_DATE('01-01-2008','DD-MM-YYYY'),'DD-MM-RRRR'),'DD-MM-YYYY') FROM DUAL;
TO_CHAR(TO_DATE(TO_DATE('01-01
------------------------------
01-01-2008
|
|
|
|
|
|
|
Re: TO_DATE function returns undesirable format [message #292339 is a reply to message #292320] |
Tue, 08 January 2008 10:37  |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Quote: | Hi Michel,
What if it is not sysdate.
|
Same thing TO_DATE on a date is just silly, logically speaking, doesn't it?
It is like if I'm going to "Ministère de l'Intérieur" (Home Office) ask for being French.
Regards
Michel
|
|
|