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>


"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

Original text of this message