date function

[jayeshp100]

List all DVDs released for the three weeks following the first Tuesday in April (where the date is derived using sql)Can some one help me answer this question above how do i find the first tuesday of april then the next three weeks, in SQL Plus

[vijay]

Hi, I can tell u LogicFirst u get that Date what ever u wantUse date Add Function According to ur requirementAnd Write query according to ur RequirementIn Every language there is lots of functions related to datesSo...

[Kcarson]

jayeshp100, I don't know how to perform this in SQL*Plus like you need, but here are some good resources that might be able to help you out:http://print.google.com/print?q=SQL*Plus+s...lr=&sa=N&tab=wp

[tisumo]

i think that you can try this way:select count(dvd_id) from dvd_tablewhere released_date between (select next_day('31-Mar-2005','Tuesday') from dual) and (select next_day('31-Mar-2005','Tuesday')+21 from dual);