Oracle to calculate the current date of 0 point to the time difference between the specified date, specify the date is the database field values, only working time calculation, unit for hours, retain two decimal places,
Which to remove Saturday day, holiday time, work time is 9 to 12 o 'clock every day, in the afternoon 13 points to 18 points,

CodePudding user response:

Establishing an auxiliary table, deposit not all date "on Saturday, holiday"
Through the auxiliary table to achieve your requirements,

CodePudding user response:

The most trouble is to handle the holiday, can through the auxiliary table to weed out the data

CodePudding user response:

Can only use the auxiliary table processing, or changes in the future will be more troublesome