insert into device_gateway(
id,
did,
gwid,
expire_time
)
values(
nextval(‘device_gateway_id_seq’),
#{deviceName, jdbcType=VARCHAR},
#{gatewayName,jdbcType=VARCHAR},
(now() + ‘1 D’)
postgresql向数据库中插入目前时间的往后一天。
最新推荐文章于 2022-11-03 11:22:36 发布
insert into device_gateway(
id,
did,
gwid,
expire_time
)
values(
nextval(‘device_gateway_id_seq’),
#{deviceName, jdbcType=VARCHAR},
#{gatewayName,jdbcType=VARCHAR},
(now() + ‘1 D’)