Oracle Timestamp

[har]

Hi,
Unable to insert 1998-07-02 14:06:48 this value in Oracle Table.
Filed Data type :Timestamp(26,6) Not Null
Log shows this error :
ORA-00932: inconsistent datatypes: expected NUMBER got TIMESTAMP

Any Idea
Thanks,
Har

[rameshrr3]

Google search could be your answer

Forum OpenACS Q&A: Oracle date/time interval fails with sum()Recently, I had to write queries using Oracle's new "standard" timestamp and ... ERROR at line 1: ORA-00932: inconsistent datatypes: expected NUMBER got ...
openacs.org/forums/message-view?message_id=394845 - 12k - Cached - Similar pages


DBAsupport.com Forums - How to Sum the intervalsORA-00932: inconsistent datatypes: expected NUMBER got INTERVAL ... SQL> create table dapi$ts (a timestamp, b timestamp); Table created. ...
forums.dbasupport.com/forums/printthread.php?s=9d90356dab0b92398f8e08f3ed48b62a&threadid=46582 - 15k - Cached - Similar pages


AskTom "Using Interval Datatype"Hi Tom, The timestamp in email sent by UTL_SMTP is 5 hours early than the EST ... at line 1: ORA-00932: inconsistent datatypes: expected NUMBER got INTERVAL ...
asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:10729709873260 - 95k - Cached - Similar pages


The contents of this file are subject to the Compiere License ...ORA-00932: inconsistent datatypes: expected NUMBER got TIMESTAMP + " AND AD_Client_ID IN (0,?)" // #5 + " AND AD_Org_ID IN (0,? ...
fisheye1.cenqua.com/browse/~raw,r=1.16/compiere/dbPort/src/org/compiere/model/MConversionRate.java - 11k - Cached - Similar pages


DBAsupport.com Forums - using TRUNC in timestampsORA-00932: inconsistent datatypes: expected NUMBER got TIMESTAMP ******************************************************************** ...
http://www.dbasupport.com/forums/archiv ... 46511.html - 15k - Cached - Similar pages


Koders - MSchedule.javacauses // ORA-00932: inconsistent datatypes: expected NUMBER got TIMESTAMP sql = MRole.getDefault(m_ctx, false).addAccessSQL ( "SELECT Name, Date1 FROM ...
http://www.koders.com/java/fid3B296CBDF ... 20061.aspx - Similar pages


Re: Problem with function based index on timestamp - dbTalk ...Default Re: Problem with function based index on timestamp - 12-15-2005 , 12:09 PM ... ORA-00932: inconsistent datatypes: expected NUMBER got - ...
http://www.dbtalk.net/comp-databases-or ... 76553.html - 24k - Cached - Similar pages


TRUNC(timestamp) ...Of course trunc(timestamp) will work, but it will be actually be a trunc(cast(timestamp ... ORA-00932: inconsistent datatypes: expected NUMBER got TIMESTAMP ...
forums.oracle.com/forums/click.jspa?searchID=-1&messageID=1243724 - 69k - Cached - Similar pages


How to Sum the intervals ...ORA-00932: inconsistent datatypes: expected NUMBER got TIME [/CODE] ... select numtoyminterval( sum( ( to_number(to_char(timestamp '3000-01-01 00:00:00' + x ...
forums.oracle.com/forums/click.jspa?searchID=-1&messageID=908703 - 55k - Cached - Similar pages


Mailing list archivesSQLException: ORA-00932: inconsistent datatypes: > expected - got CLOB ... This > needs to be replaced with NUMBER(1) as a single digit number, ...
mail-archives.apache.org/mod_mbox/incubator-roller-user/200603.mbox/%3C4419521C.1050702@youthnet.org%3E - 11k - Cached - Similar pages

[har]

I try using TO_DATE('2006-11-01 08:54:08','yyyy-mm-dd hh24:mi:ss') in user defined sql and also using Oconv(@DATE,"D YMD[4,2,2]") :' ': Oconv(@TIME,"MTS") in transformer,but i cant insert a record.
If i try to insert manula using TO_DATE('2006-11-01 08:54:08','yyyy-mm-dd hh24:mi:ss'),then i can insert record.
Any idea,where excatly i'm doing wrong..

Field datatype : Timestamp(26,6).

[kris007]

Set your action to generated sql and any one of the updated actions. Copy the generated sql in the OCI stage and then make modifications where necessary in your user-defined sql. You should hit the bull's eye. Else, post the complete sql here so that we could help you. Also use

Code: Select all

Oconv(@DATE,"D-YMD[4,2,2]") :' ': Oconv(@TIME,"MTS")

instead.

[DeepakCorning]

The safets way to handle any date columns is to do what Kris mentioned above. Declare the Column in the stage and then say generated SQL. Copy whatever the stage is doing with the timestamp column and paste it is your USRDFN query.