AND A.CLASS_PRICE_DTTM <= $RC_FromDate
This will return expected results:
AND A.CLASS_PRICE_DTTM <= to_date($RC_FromDate, 'DD-MON-YYYY')
Where $RC_FromDate is a variable populated from a Date field on your Run Control page.
Using DateTime Fields in SQR - Gotcha #343
This will return unexpected results:
This will return expected results:
Where $RC_FromDate is a variable populated from a Date field on your Run Control page.
This will return expected results:
Where $RC_FromDate is a variable populated from a Date field on your Run Control page.
Posts
0 comments:
Post a Comment