sql script help
hi,
i have this script:
select it_date,date_created,coll_date,to_char(it_date+1,'RRRRMMDD') "date_dispatch"
from iteneraries
where code='1083001'
however i do need to add conditions from which the "date_dispatch" will not fall on saturdays, sundays
and holidays. any help
thanks,
i have this script:
select it_date,date_created,coll_date,to_char(it_date+1,'RRRRMMDD') "date_dispatch"
from iteneraries
where code='1083001'
however i do need to add conditions from which the "date_dispatch" will not fall on saturdays, sundays
and holidays. any help
thanks,
0