1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

[SQL] To_Date is giving me ORA-01722: invalid number [closed]

Discussão em 'Outras Linguagens' iniciado por Stack, Julho 22, 2021.

  1. Stack

    Stack Membro Participativo

    Sample Value of LOGOUT column from the table : 2021-07-08 14:57:34.000

    I am having the below SQL server query as part of my sql script and it is working fine.

    MAX(ISNULL(LOGOUT, '2999-12-31')) AS MAX_LOGOUT


    i have converted this line of query in to oracle as below

    MAX(NVL(LOGOUT, TO_DATE('2999-12-31', 'YYYY-MM-DD'))
    ) AS MAXLOGOUT


    I am getting the error ORA-01722: invalid number. How to fix this error

    Continue reading...

Compartilhe esta Página