Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL incorrectly truncates IW dates in Oracle 7.3.4
In article <73fpj7$6nn$1_at_cdn-news.telecom.com.au>,
"Brad Slocomb" <bslocomb_at_wconper1.telstra.com.au> wrote:
> Hello,
>
> Why does "select trunc(to_date('28-NOV-98','DD-MON-YY'),'IW') from dual"
> return 30-NOV-98 under Oracle 7.3.4 (not so for 7.3.2 or 7.2.3)?
>
> The error occurs with the trunc of any Saturday date using the IW format.
> The above query run with dates of 27-NOV-98 and 29-NOV-98 returns
> 23-NOV-98 as one would expect.
>
> I have tested this under 7.3.4.0 and 7.3.4.3, and on different instances
> running
> on both HP-UX and Solaris servers.
>
> I rely on the IW format for generating weekly reports on a Mon-Sun basis.
> The error means the query results that are being returned are most likely
> incorrect, i.e. if the rows being grouped includes Saturdays.
>
> Is this a bug or have I missed something?
>
> Thanks,
> Brad
>
>
Dunno. Your query produces the 30-NOV-98 result in 8.0.4 on Solaris 2.6.
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Nov 25 1998 - 14:57:07 CST