Today I face a problem in Date Comparison please help me in out thanks in advance... problem mention below:-
In my Table there is a Column Named DNCDATE, format of this Column is DateTime. when i pass a varchar type date then it will not compute any output. e.g DNCDATE>='29 Sep 2012' when i cast the column then it will give me output but it will take longer time to compute the result e.g. CAST( DNCDATE as DATE)>='29 Oct 2012'..
Please guide me about the date comparison and help me out...
Note :- DNCDate Column's Max Value is 2nd Oct 2012, which need to pulled out in our query