Book a Demo

Author Topic: ORACLE 10 TIMESTAMP WITH TIME ZONE Datatype  (Read 2574 times)

gldnrtvr

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
  • I
    • View Profile
ORACLE 10 TIMESTAMP WITH TIME ZONE Datatype
« on: July 16, 2007, 12:20:19 pm »
Good Day,

By looking in the documentation, I found out how to add a new datatype to the ORACLE database profile.  However, I have run into a snag.  The template for a datatype seems to be {TYPE} {MODIFIERS}  so that I can add
TIMESTAMP and set default length of 6, with a max of 9 and get a resulting field of TIMESTAMP(6) (timestamp percision is 0-9 decimal places of the second)
However, if I try to do TIMESTAMP WITH LOCAL TIME ZONE it create DDL as one would expect:
TIMESTAMP WITH LOCAL TIME ZONE (6)
but this is a syntax error.  The correct clause is:
TIMESTAMP (6) WITH LOCAL TIME ZONE

Is there a way to make this work?  Fortunately I found out that I didn't need quite that granularity for the current purpose, but in future ORACLE 10 products, I may need to have this datatype.

Fortunately the INTERVAL DAY TO MONTH and INTERVAL HOUR TO SECOND have no modifiers.
Mark Hennning
Principal Software Engineer
ITT Corp
http://aes.itt.com