Question: how to calculate number of weeks between two dates in oracle?
Answer: To count the number of weeks between two dates, you use one of the Week Difference functions. If the current date is 26/6/2009 and the baby's due date is 25/12/2009, the number of weeks until the baby is due is 26.