How to store Fraction of a Second
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to store Fraction of a Second

Hybrid View

  1. #1
    Join Date
    Jun 2000
    Location
    chennai,tamil nadu,india
    Posts
    159
    Hi,
    Can anyone tell me how to store a 3 digit fraction of a second in a date column.

    thanks

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    SQL> SELECT CURRENT_TIMESTAMP(6) FROM DUAL;

    CURRENT_TIMESTAMP(6)
    ---------------------------------------------------------------------------
    15-JUL-02 03.39.15.959608 PM -06:00

    current_timestamp(N) where N = # of digits for precision

    Date datatype won't work for you. Need something like timestamp datatype which came out in 9i.

Posting Permissions

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



Click Here to Expand Forum to Full Width