In Reporting Services I have had big problems to compare RS parameters defined as Date/Time with columns in an Oracle Database defined as Date.
The problem is when searching with:
"oracle column" <= "date entered in Date/Time parameter".
The workaround I use is:
AND LMS_LOGINLOG.LOGINDATE >= :param_FromDate
AND LMS_LOGINLOG.LOGINDATE -1 <= :param_ToDate
AND LMS_LOGINLOG.LOGINDATE -1 <= :param_ToDate
Inga kommentarer:
Skicka en kommentar