Skip to Main Content
Forums

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!

Previous business day in sql query

763735Jul 27 2010 — edited Mar 30 2011
Hi,
Is there a way to calculate the previous business day on teh sql query without using a function call.
Typically in the query where clause as seen below:
eg)
select * from sales where sale_date ='+previous_buss_day+'
If so please let me know....Thnx in advanc.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 27 2011
Added on Jul 27 2010
#sql
6 comments
9,585 views