DB2 日付操作 - MyMemoWikiOldSELECT current date FROM sysibm.sysdummy1 SELECT current time FROM sysibm.sysdummy1 SELECT current timestamp FROM sysibm.sysdummy1 関数を使用して年、月、日、時、分、秒、およびマイクロ秒の部分を個別に抽出 YEAR (current timestamp) MONTH (current timestamp) DAY (current timestamp) HOUR (current timestamp) MINUTE (current timestamp) SECOND (current timestamp) MICROSECOND (current timestamp) 2つの日付の間の日数を計算
