Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    5

    Question Unanswered: Timestamp in Oracle9i

    Hi,
    CAn anyone help me in knowing the internal format of Timestamp
    datatype in Oracle9i.
    Any help is appreciated.

  2. #2
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    hi,

    it depends on the NLS settings when creating the database.
    Normally it is American, so the time stamp format look like MM-DD-YY HH24:MIS.
    But you can change the way it looks by formatting the output or change a certain date in a certain format to the internal format without knowing what that internal format is by using the TO_DATE function

    Hope that helps
    Edwin van Hattem
    OCP DBA / System analyst

  3. #3
    Join Date
    Oct 2003
    Posts
    5

    Timestamp Internal Representation

    Hi Evan,

    Thanks for ur info. But I also want the No. of Bytes that
    Timestamp datatype occupies in Oracle9i.
    Any help is appreciated.

  4. #4
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    Hi,

    a DATA datatype takes 7 bytes.
    Using the TIMESTAMP datatype it takes 7 to 11 bytes depending on the value stored in the column. Storing sysdate in a TIMESTAMP column takes 7 bytes.

    metalink Doc ID: 332623.999

    hope that helps
    Edwin van Hattem
    OCP DBA / System analyst

Posting Permissions

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