「Access 日付演算」の版間の差分
ナビゲーションに移動
検索に移動
(ページの作成:「==Access 日付演算== =====日付間隔を求める===== DateDiff(strInterval, varDate1, varDate2, lngWeek, lngYear) SELECT DateDiff("m","2008/12/01","2009/11/…」) |
|||
1行目: | 1行目: | ||
− | ==Access 日付演算== | + | ==[[Access 日付演算]]== |
=====日付間隔を求める===== | =====日付間隔を求める===== | ||
DateDiff(strInterval, varDate1, varDate2, lngWeek, lngYear) | DateDiff(strInterval, varDate1, varDate2, lngWeek, lngYear) | ||
− | SELECT DateDiff("m","2008/12/01","2009/11/30") as | + | SELECT DateDiff("m","2008/12/01","2009/11/30") as MONTH_[[R]]ANGE |
− | FROM | + | FROM [[TEST]]_TABLE; |
=====日付を加算===== | =====日付を加算===== | ||
11行目: | 11行目: | ||
SELECT CDate(DateAdd("d", 30,Now())) as 30DaysAfter | SELECT CDate(DateAdd("d", 30,Now())) as 30DaysAfter | ||
− | FROM | + | FROM [[TEST]]_TABLE; |
---- | ---- |
2020年2月16日 (日) 04:21時点における最新版
Access 日付演算
日付間隔を求める
DateDiff(strInterval, varDate1, varDate2, lngWeek, lngYear)
SELECT DateDiff("m","2008/12/01","2009/11/30") as MONTH_RANGE FROM TEST_TABLE;
日付を加算
DateAdd(strInterval, lngNum, varDate)
SELECT CDate(DateAdd("d", 30,Now())) as 30DaysAfter FROM TEST_TABLE;
© 2006 矢木浩人