Although parts of your question are not quit clear,
I asume you can use the funtion trunc(sysdate,'yyyy').
So :
where trunc(t1.date,'yyyy') = trunc(e_date,'yyyy')
|
Results 1 to 3 of 3
Threaded View
|
Click Here to Expand Forum to Full Width |