Date truncation problem V8 vs. V7

Posted by 'Ben Andriantsiferana' on August 06, 2001 at 13:31:05 EST:

Hi,

Here's a weird bug I've encountered, following this query:

select trunc(to_date('20010630','yyyymmdd'),'iw') monday
from dual

the result should be 2001/06/25.

On V8, the answer is correct, on V7.3.4 it yields 2001/07/02
i.e the monday of the week after, which is false.

If you ask for next day i.e 2001/07/01, the result is correct
on both versions which is 2001/06/25

I know I can use anything else, to avoid this trouble but
it remains an important bug I think.

Look forward to reading from you.

Thanks

Name:
E-Mail:
Subject:
Message: : Hi, : Here's a weird bug I've encountered, following this query: : select trunc(to_date('20010630','yyyymmdd'),'iw') monday : from dual : the result should be 2001/06/25. : On V8, the answer is correct, on V7.3.4 it yields 2001/07/02 : i.e the monday of the week after, which is false. : If you ask for next day i.e 2001/07/01, the result is correct : on both versions which is 2001/06/25 : I know I can use anything else, to avoid this trouble but : it remains an important bug I think. : Look forward to reading from you. : Thanks