Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Posts
    3

    Unanswered: Oracle time (hundreths of a second)

    Doing a Visual Basic front end for an oracle database of time that is recorded. The time is in the form of: HH:MMS.hundreths.
    How does Oracle handle time that goes beyond seconds?? Thanks Arot.

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    The standard DATE data type only hold date and time to an accuracy of one second. In 9i you can use the new TIMESTAMP and INTERVAL data types which will hold time to the precision you require. Alternatively if you dont have 9i then you could use a DATE field and a number field to store the hundredths of a second but you would need to get the time from outside oracle i.e. maybe you VB app or from the OS on the dtabase server.

    Alan

  3. #3
    Join Date
    Apr 2003
    Posts
    3

    hanks man....

    I get ya. Makes sense when you put it that way. Beautiful, you're a Beautiful personson

Posting Permissions

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