Query
select
abs(to_number(to_char(to_date('&FromDT_dd_mon_yyyy','dd-mon-yyyy'),
'WW'))
2* -
to_number(to_char(to_date('&ToDT_dd_mon_yyyy','dd-mon-yyyy'),'WW')) ) "Number
of weeks" from dual
acehints.com Copyright 2011-20 All Rights Reserved | Site Map | Contact | Disclaimer