INSERT INTO sfa_t_cir_ordercode
(
ordercodeid,
orderdate,
ordercode
)
VALUES
(
cast(sfa_f_new_uuid(CAST(random() * 100000 AS INTEGER)) AS uuid),
to_char(now(),'yyyy-mm-dd'),
iordercode
);
原文链接:https://www.f2er.com/postgresql/196173.htmlINSERT INTO sfa_t_cir_ordercode
(
ordercodeid,
orderdate,
ordercode
)
VALUES
(
cast(sfa_f_new_uuid(CAST(random() * 100000 AS INTEGER)) AS uuid),
to_char(now(),'yyyy-mm-dd'),
iordercode
);
原文链接:https://www.f2er.com/postgresql/196173.html