How do deal with dates and frequencies(days of week)

[Pradeep Bhat]

I want to select some date based on one of its Date field.
The data should be between 2 dates (say the field value is between date A and date B)..and should only occur on certain days of the week...say 147....(Mon, Thurs, Sunday)


Can this be done???

[Agador Paloi]

Should not be any problem. Use to_char with 'D' mask to get the numeric
day of the week.
For example to get Sundays data
between date_a and date_b:

  

SELECT 
  at.some_date,  at.something_else
FROM
     a_table at
 WHERE
      at.some_date      <   date_b
AND at.some_date     >  date_a
AND to_char(at.some_date,'D') =  '1'