How to insert Time Stamp for SQL Database

[Former Member]

Hi All,

I need to insert timestamp in milliseconds into the SQL database. The database is taking date but when i'm trying to insert along with the time, it is throwing the following error "Incorrect syntax near 12".

I have given the datatype as DateTime in XI.

Please let me know how i can solve this issue.

Regards,

Manisha Gogineni

[GabrielSagaya]

This blog will help you

/people/alessandro.berta/blog/2005/10/04/datetime-datatypes-and-oracle-database