Need Help In Moditying TO_DATE Function? Help

[bmann]

I have a date from SQL server that looks like this:

2004-09-11 07:51:44.533000000


How do I get this to work with this To_Date Function which looks like this:

"to_dateTIMESTAMP,'YYYY-MM-DD HH24:MI:SS')"


This function works when the date looks like this:

2004-09-09 18:18:33


How do I solve this problem? Thses dates are exported from sql server. Thanks I would appreciate anyone's help.

 

[nagornyi]

If fractional part of a second can be discarded, you may just use

to_date(substr(:TIMESTAMP,1,19),'YYYY-MM-DD HH24:MI:SS')

 

[bmann]

Thanks nagornyi. That worked. My background is SQL server but I am starting to learn Oracle. I apppreciate your help.