Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003
    Posts
    123

    Unhappy Unanswered: timestamp datatype in Oracle 9i

    Does timestamp datatype in Oracle 9i gives time upto milli second level

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: timestamp datatype in Oracle 9i

    Originally posted by jaggu
    Does timestamp datatype in Oracle 9i gives time upto milli second level
    Yes, up to 9 decimal places for fractional seconds, as is well documented in the manuals.

  3. #3
    Join Date
    Aug 2003
    Posts
    123
    Hi andrewst,
    Thanks for your replay.
    here is the sql, please tell me what was wrong
    create table t1(f1 int,f2 timestamp(9))
    --table created
    insert into f1 values(1,sysdate);
    I run this sql 3 times Continuesly
    --3 rows created
    select * from t1
    my out put is as follows

    F1
    ----------
    F2
    ---------------------------------
    1
    19-AUG-03 10.09.18.000000000 AM

    1
    19-AUG-03 10.09.18.000000000 AM

    1
    19-AUG-03 10.09.18.000000000 AM

    here all the timestamp fields are same.

    I would appreciate if you tell me where I went wrong.

    --Jaggu

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Originally posted by jaggu
    Hi andrewst,
    Thanks for your replay.
    here is the sql, please tell me what was wrong
    create table t1(f1 int,f2 timestamp(9))
    --table created
    insert into f1 values(1,sysdate);
    I run this sql 3 times Continuesly
    --3 rows created
    select * from t1
    my out put is as follows

    F1
    ----------
    F2
    ---------------------------------
    1
    19-AUG-03 10.09.18.000000000 AM

    1
    19-AUG-03 10.09.18.000000000 AM

    1
    19-AUG-03 10.09.18.000000000 AM

    here all the timestamp fields are same.

    I would appreciate if you tell me where I went wrong.

    --Jaggu
    SYSDATE is a DATE function, only accurate to the second. Use SYSTIMESTAMP instead.

Posting Permissions

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