Re: Playing With Truncate and Date
From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 4 Mar 2011 17:27:58 +0100
Message-ID: <4d711309$0$27514$426a74cc_at_news.free.fr>
ERROR at line 1:
ORA-01858: a non-numeric character was found where a numeric was expected
Date: Fri, 4 Mar 2011 17:27:58 +0100
Message-ID: <4d711309$0$27514$426a74cc_at_news.free.fr>
"Nimish" <nimishsoft_at_gmail.com> a écrit dans le message de news:
b35b4edf-2e2a-4801-a971-790f8c442784_at_d23g2000prj.googlegroups.com...
| Check Out This link
| http://nimishgarg.blogspot.com/2011/03/playing-with-truncate-and-date.html
Nothing more (rather much less) than the documentation and even wrong:
SQL> SELECT TRUNC( TO_DATE('27-FEB-2011') -1,'DAY')+1 FROM DUAL; SELECT TRUNC( TO_DATE('27-FEB-2011') -1,'DAY')+1 FROM DUAL
*
ERROR at line 1:
ORA-01858: a non-numeric character was found where a numeric was expected
Regards
Michel
Received on Fri Mar 04 2011 - 10:27:58 CST