如何使用{ ts }创建带有默认日期列的表？

Question

Oracle数据库11g速成版11.2.0.2.0 -64位生产

create table my_table ( 
    transaction_date DATE DEFAULT { ts '1900-01-01 00:00:00' } NULL 
)

错误--

ORA-00911: invalid character
00911. 00000 -  "invalid character"
*Cause:    identifiers may not start with any ASCII character other than
           letters and numbers.  $#_ are also allowed after the first
           character.  Identifiers enclosed by doublequotes may contain
           any character other than a doublequote.  Alternative quotes
           (q'#...#') cannot use spaces, tabs, or carriage returns as
           delimiters.  For all other contexts, consult the SQL Language
           Reference Manual.

由于上面的create语句是由第三方软件生成的，不使用date或to_date()的正确语法是什么？

Answer 1

无论是哪种语法，在Oracle中都是不正确的。

用这个：

create table my_table ( 
    transaction_date DATE DEFAULT timestamp'1900-01-01 00:00:00' NULL 
);