+ Reply to Thread
Results 1 to 2 of 2

Thread: sql query execution error : ORA-01843

  1. #1
    Junior Member
    Join Date
    Jan 2012
    Posts
    15

    sql query execution error : ORA-01843

    I am trying to execute the following query :
    Code:
    SELECT ABC (time_tb.ddate, '2012-12-22')
    FROM time_tb
    But i get this error:

    Code:
    java.sql.SQLException: ORA-01843

  2. #2
    Junior Member
    Join Date
    Jan 2012
    Posts
    35
    Try this :
    Code:
    SELECT  ABC (time_tb.ddate, to_date('2012-12-22', 'YYYY-MM-DD') )
    FROM time_tb

+ Reply to Thread

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts