DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Using TIMESTAMP and TIMESTAMP WITH LOCAL TIME ZONE

  1. #1
    Join Date
    Mar 2001
    Posts
    4
    when I try to create tables with columns of datatype TIMESTAMP and TIMESTAMP WITH LOCAL TIME ZONE I get unrecognized datatype errors.

    CREATE TABLE orders
    ( order_id NUMBER(12)
    , order_date TIMESTAMP WITH LOCAL TIME ZONE NOT NULL
    , order_mode VARCHAR2(8)
    , customer_id NUMBER(6) NOT NULL
    , order_status NUMBER(2)
    , order_total NUMBER(8,2)
    , sales_rep_id NUMBER(6)
    , CONSTRAINT order_mode_lov
    CHECK (order_mode in ('direct','online'))
    , constraint order_total_min
    check (order_total >= 0)
    ) ;


  2. #2
    Join Date
    Jul 2000
    Posts
    296
    Because TIMESTAMP and TIMESTAMP WITH LOCAL TIME ZONE are not datatypes in Oracle.
    Check Oracle SQL Reference for valid datatypes:
    http://technet.oracle.com/docs/produ...a85397/toc.htm

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