Postgresql/DML
提供: 初心者エンジニアの簡易メモ
データ挿入
insert into test1 values(1,'taro', true); insert into test1 values(2,'hiro', false); insert into test1 values(3,'masa', false);
日付の加算
select updated + cast('30 dates' as interval);
insert into test1 values(1,'taro', true); insert into test1 values(2,'hiro', false); insert into test1 values(3,'masa', false);
select updated + cast('30 dates' as interval);
|
|
