You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

peoplesoft psquery

No replies
Guest's picture
Guest

hi
iam working upgradation 8.8/9.1 PSQUERY .....I HAVE ONE ISSUE IN 8.8 DATA IS COMMING BUT IN 9.1 DATA IS NOT COMING .........IN 8.8 that is date format'YYYY:MM:DD' BUT IN 9.1 SQL USING TIMESTAMP i.e....'YYYY-MM-DD-HH24.MI.SS.FF'.......................my code is like dis
IN 8.8
ROUND((to_date( TO_CHAR(A.SHIP_DATE,'YYYY-MM-DD'),'YYYY-MM-DD')-
to_date( TO_CHAR(C.TS_CUST_REQ_DATE,'YYYY-MM-DD'),'YYYY-MM-DD'))-0.5),
DECODE((SIGN(ROUND((to_date( TO_CHAR(A.SHIP_DATE,'YYYY-MM-DD'),'YYYY-MM-DD')-
to_date( TO_CHAR(A.REQUEST_DATE,'YYYY-MM-DD'),'YYYY-MM-DD'))-0.5))),0,100,-1,100,0),
IN 9.1
SUBSTR( TO_CHAR(CAST((C.DATETIME_ADDED) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS."0000"'),1,10),
ROUND((to_date( TO_CHAR(CAST((A.SHIP_DTTM) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'),'YYYY-MM-DD-HH24.MI.SS.FF')-
to_date( TO_CHAR(C.TS_CUST_REQ_DATE,'YYYY-MM-DD'),'YYYY-MM-DD'))-0.5),
DECODE((SIGN(ROUND((to_date( TO_CHAR(CAST((A.SHIP_DTTM) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'),'YYYY-MM-DD-HH24.MI.SS.FF')-
to_date( TO_CHAR(A.REQUEST_DATE,'YYYY-MM-DD'),'YYYY-MM-DD'))-0.5))),0,100,-1,100,0),
ROUND((to_date( TO_CHAR(CAST((A.SHIP_DTTM) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'),'YYYY-MM-DD-HH24.MI.SS.FF')-
to_date( TO_CHAR(CAST((A.SCHED_DTTM) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'),'YYYY-MM-DD-HH24.MI.SS.FF'))-0.5), BUT IT SHOEING ORC 1830 DATE FORMAT PICTURE ENDS ERRORAND NOT VALID MONTHS SHOWS...ANY BODY CAN RECTIFY DIS ISSUE PLZ