Results 1 to 2 of 2

Thread: -------------------URGENT-------------------------

  1. #1
    BOBBY Guest

    Default -------------------URGENT-------------------------

    hai<BR>In oracle i declared the date datatype as date and i gave this code in asp when iam executing i am getting the below error can you please tell me where is the problem and if the problem exist with oracle how can i declare datatype in oracle.<BR>ourdate = now()<BR><BR>SQLMNS=SQLMNS & "to_date(&#039" & ourdate & "&#039,&#039dd/mm/yyyy HH24:MI:SS&#039))"<BR><BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR><BR>[Oracle][ODBC][Ora]ORA-01841: (full) year must be between -4713 and +9999, and not be 0 <BR><BR>line 29 <BR><BR>bye<BR>thanks in advance<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: -------------------URGENT---------------------

    &nbsp;<BR> Have you displayed SQLMNS after it is completely built to see that the spacing and puntuation around the TO_DATE(...) are correct in the SQL statement? That will let you see what Oracle is seeing and may point you at the problem.<BR><BR><BR><BR>

Posting Permissions

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