caramelkaps (4/10/2012)

---

I meant to say milliseconds....whatever it records after seconds I want to bring it over to oracle.

any value after seconds is currently becoming 00000 in oracle.

Also I tried using to_char and giving it a format 'dd/mm/yyyy hh24:mi:ss:ssss' and insert it into oracle varchar column but it just repeats the seconds value

For eg

sql server Oracle

source_id source id

01/01/2012 6:30:45:346 01/01/2012 6:30:45:4545 .

Thanks.