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>