SQL20448N "05/09/2016" cannot be interpreted using format string "YYYY-MM-DD" for the TIMESTAMP_FORMAT function

4 votes

1 answer

6192 views

db2-9.7

                          I am getting below error in db2 when executing the sql query-

> SQL20448N  "05/09/2016" cannot be interpreted using format string
> "YYYY-MM-DD" for the TIMESTAMP_FORMAT function.

here is my sql qyery-

    SELECT DLR_CD,
           FIN ,
           YEAR(TO_DATE(CURRENT_DATE ,'YYYY-MM-DD'))-YEAR(TO_DATE(CRTNG_DTE,'YYYY-MM-DD'))
           AS AGE 
    FROM ASPECT.RO_CAR_PARK_EXTRACT WHERE YEAR = PARM_YEAR

what could be the reason for this?

Database - DB2 v9.7.200.358
Platform-  home basic 7
 
                        

Asked by user88416

May 9, 2016, 10:19 AM
Last activity: May 9, 2016, 12:10 PM

SQL20448N "05/09/2016" cannot be interpreted using format string "YYYY-MM-DD" for the TIMESTAMP_FORMAT function

Related Questions