7 Replies Latest reply: Jun 22, 2014 2:29 PM by Massimo Grossi RSS

    Script error with date field

    ahnet ceylan

      Hello,

      I have a script like below

      :

      SELECT /*+ parallel(8)*/

      --              TRUNC (TO_DATE (TIMESTAMP, 'YYYY-MM-DD HH24:MI:SS')) TARIH,

      --               SUBSTR (TIMESTAMP, 1, 4) AS YIL,

      --               SUBSTR (TIMESTAMP, 6, 2) AS AY,

      --               SUBSTR (TIMESTAMP, 9, 2) AS GUN,

      --               SUBSTR (TIMESTAMP, 12, 2) AS SAAT,

      --               SUBSTR (TIMESTAMP, 15, 2) AS DAKIKA,

                     REPLACE (REPLACE (UPPER (DOCUMENT), 'E:\DOCUMENTS\'),

                              '.QVW')

                        DOCUMENT,

                     TYPE,

                     USERS

                FROM LOGS A

      In this script When I comment date fields it works fine. But the whole script does not work. It gets QVX_UNEXPECTED_END_OF_DATA

      error.

      TIMESTAMP field is varchar data type and its format 'YYYY-MM-DD HH24:MI:SS .I change into date field.

      a few times ago whole script was working.

       

      İs there any one who has thougt about this problem ?

      Thanks