Re: Playing With Truncate and Date
From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Sun, 6 Mar 2011 06:04:17 -0800 (PST)
Message-ID: <74238a32-1a3a-4699-8f1a-1a05a543f9f8_at_s18g2000prg.googlegroups.com>
Michel:
Date: Sun, 6 Mar 2011 06:04:17 -0800 (PST)
Message-ID: <74238a32-1a3a-4699-8f1a-1a05a543f9f8_at_s18g2000prg.googlegroups.com>
Michel:
# SQL> 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
Works for me ... Received on Sun Mar 06 2011 - 08:04:17 CST