Start date of a week in SQL

From: Werner Hartmann <whartmann_at_prs-gmbh.de>
Date: Thu, 01 Feb 2001 17:25:46 +0100
Message-ID: <3A798E0A.6C298D5F@prs-gmbh.de>

I'm looking for a solution of my problem with week formating in SQL !

Example:

---

select *
from xyz
where to_char (date, 'IW.YYYY') = '43.2000'

This effects, no index on column date is used !

Searched Solution :

---

select *
from xyz
where date between <start date of week> and <end date of week>

How can I get the start date and end date of a given week like '43.2000' ?
I try it with to_date() function but formating with 'IW.YYYY' is not allowed.

Thanks in advance
Werner Received on Thu Feb 01 2001 - 10:25:46 CST