posted 16 years ago
Hi,
I'm looking for an Oracle SQL function that will return the first day of the week as a number because i want to issue an SQL statement that will return all the days between the first day of the week and the current day, as an example, a pseudo code will look like this :
select * from table_name where date_field between the first day of this week and this current day.
Please feel free to advice ...
Thanks in advance ...
Vassili ...
SCJP 5.0, SCWCD 1.4, SCJA 1.0