PostgreSQL/日付・時刻・時間の計算・演算 の編集

*日付・時刻・時間の計算・演算 [#seb4d5a5] #contents **nヶ月後、nヶ月前の日付を求める [#c0cbdf3b] select NOW()+'1 months' ; select cast(domain AS DATE)+cast('1 months' AS INTERVAL) from csv_upload ; **n月のものを取得 [#me6c4bde] SELECT * FROM t_server WHERE to_char(se_use_date,'yyyymm') like '".$ym."'";

*日付・時刻・時間の計算・演算 [#seb4d5a5] #contents **nヶ月後、nヶ月前の日付を求める [#c0cbdf3b] select NOW()+'1 months' ; select cast(domain AS DATE)+cast('1 months' AS INTERVAL) from csv_upload ; **n月のものを取得 [#me6c4bde] SELECT * FROM t_server WHERE to_char(se_use_date,'yyyymm') like '".$ym."'";