timestamp[] postgresql

来源:互联网 发布:wordpress yoast seo 编辑:程序博客网 时间:2024/05/18 13:47


CREATE TABLE gcdeposit
(
  gcdepositid serial NOT NULL,
  datearray timestamp without time zone[],
  deposittotalamount numeric,
  entryid integer,
  inserttime timestamp without time zone

);


插入新数据到 timestamp without time zone[]

INSERT INTO gcdeposit(

             datearray, deposittotalamount, entryid, inserttime)
    VALUES ( '{"2014-5-6","2013-3-4"}', 5460.00, 1, now());
0 0
原创粉丝点击