GBase8s新建表时，怎么给DATETIME类型赋默认值为现在时间

Question

我现在所使用的sql如下

CREATE TABLE AAA.test(
  ID         SERIAL         PRIMARY KEY,
  NAME       VARCHAR(40)    NOT NULL,
  AGE        INT            NOT null,
  JOIN_DATE  DATETIME YEAR TO SECOND DEFAULT SYSDATE YEAR TO SECOND
);

报错信息如下

SQL 错误 [ErrorCode : -556]  [SQLState : IX000] : Cannot create, drop, or modify an object that is external to current database.

Answer 1

@生命之源 0
@GBASE数据库