Relative Content

Tag Archive for sqlmysqlplsqlplsqldeveloperplsql-package

Calculate Difference between two dates without including weekends(Saturday and Sunday) in PL?SQL

I need to calculate Daysin_process between two dates such that Saturday and sunday are not included .Also it should consider start date and end date in calculation.
for example 1 – start_date = 26-07-2024 and end_date = 29-07-2024 so Daysin_process will be 2 as it excludes saturday and sunday.
example 2 – if start_date = 28-07-2024 (sat) and end_date = 29-07-2024(mon) Daysin_process = 2 excludes sunday