torsdag 16 juni 2011

RS Date/Time parameter format vs Oracle Date format

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

Inga kommentarer:

Skicka en kommentar