Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Noida, India.

    Unanswered: Millisecond in timestamp field.

    Using oracle version

    created a table with column that has type timestamp.

    This insert does not work:

    insert into aa values (to_timestamp('10-Jan-04 11:13:34.001','dd-Mon-yy'));

    error is: date format not recognized

    how to insert millisecond in timestamp field?
    Oracle can do wonders !

  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    Use 'FF' instead of 'ms' for miliseconds. 'FF' stands for the fractional seconds; always use two FF's, regardless of the number of decimal digits you wish to see or use.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts