17,086
社区成员
发帖
与我相关
我的任务
分享
sql="select DISTINCT POSITION_NBR , INACTIVE_EFFECTIVE_DT from POSITION where INACTIVE_EFFECTIVE_DT between to_date(" + fromd + ", 'MM/dd/yyyy') and to_date(" + tod + " ,'MM/dd/yyyy')" ;
sql="select DISTINCT POSITION_NBR , INACTIVE_EFFECTIVE_DT from POSITION where INACTIVE_EFFECTIVE_DT between to_date("+from+ ",'MM/dd/yyyy')
and to_date("+to+" ,'MM/dd/yyyy')" ;