Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Inputting milliseconds in Oracle DB

657520Sep 17 2008 — edited Sep 17 2008

Hi,
We are using Oracle 10g DB where we require to make entries of timestamp with milliseconds.
The scenario is as below:
- data is being fetched from MS SQL Server 2005 DB
- date feild in MS SQL DB is in YYYY-MM-DD HH:MM:SS.MS format (e.g: 2008-03-04 11:05:05.293)
- while inserting same in Oracle DB I am getting Oracle error : ORA-01861: literal does not match format string
- this because date format mismatch
- in order to go ahead i have modified the date field in table (Oracle) from TIMESTAMP (DD-MON-YYYY HH.MI.SS) to VARCHAR2

Can anybody please suggest what datatype should i choose to accomodate milliseconds in Oracle table?

Regards
Abhinov

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 15 2008

Added on Sep 17 2008

#general-database-discussions

2 comments

3,808 views