Peoplesoft
Peoplesoft solutions
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment