SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to get the last(latest or previous) working day

Satyam ReddyJul 20 2010 — edited Jul 20 2010

hi,

using sysdate we may be getting today's date and sysdate-1 will be fetching the yesterday's date. but if sysdate-1 turns to be sunday or a holiday then we need to get the previous date to that holiday date .THe list of holidays are in lt_list_holidays. The Holiday date shall be the holiday_date column. I need a query which displays the last (latest or previous) working day ..

Please advice

Edited by: vine on Jul 20, 2010 5:30 AM

Edited by: vine on Jul 20, 2010 5:51 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 17 2010

Added on Jul 20 2010

9 comments

2,415 views