Date Formats

From: Bobby (gadirajuv_at_hotmail.com)
Date: 11/24/04 

Date: Wed, 24 Nov 2004 11:05:05 -0800

I'm trying to transfer a table of values from SQL Server to Oracle. I've 3
date fields in the table. When transferring the data, I used
      Select convert(Datetime, Ship_date,101) as ShipDate,
                convert(Datetime,Last_Tracked_Date,101) as Last_Tracked_date,
                convert(Datetime,Actual_Delivery_Date,101) as
Actual_Delivery_Date
      from Tablename

   But I get an error displaying that the null value cannot be inserted into
T$LTDT.
  this field is present in Oracle and corresponds to LastTracked Time.
  all the records in SQL Server have the value but i am not sure whats wrong.
  Could someone help me out please??
 thanks in advance, 

-- 
Bobby

Relevant Pages

  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ...
    (comp.databases.oracle.misc)
  • Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
    ... "Writers block readers and readers block writers in SQLServer. ... getting around this fundamental issue and because of it SQL Server ... admitted they can happen in Oracle, I guess Oracle should never been used ... isolation level but you will always disagree because you follow doctorine ...
    (comp.databases.oracle.server)
  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... If it was the update statement that references ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... There are however differences how both products deal with concurrency; in Oracle readers don't get blocked while this may happen in SQL Server. ...
    (comp.databases.oracle.misc)
  • Re: Import problems on Windows Server
    ... XP is fine, so is Vista, like you I use them day in day out, around 12 hours ... a day myself too - laptops and the desktop i'm writing this on. ... I use SQL Server on XP and Vista for writing and demo'ing stuff, ... those are the same problems in the Oracle world. ...
    (comp.databases.oracle.server)
  • Re: command line vs grid control
    ... have Oracle on-site for their line-of-business applications. ... customers that Oracle(all of its products not just the RDBMS) run on ... SQL Server where appropriate. ... Written any shell scripts in Windows to ...
    (comp.databases.oracle.server)
Loading