Tuesday, August 10, 2010

PT 8.50 Date Fromat ERROR in SQR

ORA-01830: date format picture ends before converting entire input string
TRUNC(TO_DATE(DAT1.UPD_DTTM)) = to_date($AsOfDate, 'DD-MON-YYYY') – solution AND TRUNC(TO_DATE(DAT1.UPD_DTTM)) = to_date($AsOfDate, 'DD-MON-YYYY HH24:MI:SS')

No comments:

Post a Comment