If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: select entries from whole week

Hello,

I'd like to get all entries from "the whole week" (begin: Monday end: Sunday)
from e.g the day sysdate - 222 (today: 20.10.2004) .This means all entries with a date between 08.03.2004
and 14.03.2004 (including the borders !)

I get a date_offset and try the select all entries from "today regarding this date", "yesterday regarding this
date", "whole week regarding this date",
and later "whole week forward/backward regarding this date" --> therefore the input parameter DATE_CURRENT

Now I have the problem of implementing the "whole week " solution suggested by shoblock in the procedure.

Don't understand what the "problem of implementing the whole week" is. It appears to in your code. BTW, don't store dates as varchars. You calc a date, convert to char, then convert back to date later - this makes no sense.

Week Interval problem ...

Hi.

I have a problem working with dates. Its like this:
1 - Imagine I have an date Interval (i.e. 01-01-2004 and 31-05-2004);
2 - Imagine I need to know the Week Interval between those 2 weeks;
3 - Imagine that I use the next statement to access week number, in ORACLE: TO_CHAR(TO_DATE(date_field, 'dd-mm-yyyy'), 'IW'));
4 - Imagine that I need the Week Interval in ONLY ONE Select;

Is there any way to retrieve that Info from one single Select to the DUAL table, for instance ???