More than 5 years have passed since last update.

DB2DBA: DB2の日付操作でプレミアムフライデー判定

SQL
db2
ネタ

Last updated at 2017-02-28Posted at 2017-02-24

SELECT
    CASE
        WHEN
            dayofweek(current date) = 6     -- Sun=1,Mon=2...
            AND month(current date + 7 day) <> month(current date)
            THEN 'PREMIUM FRIDAY!'
        ELSE NULL
    END
FROM
    sysibm.sysdummy1

参考資料

developerWorks 日本語版
- DB2の基礎: 日付と時刻で遊ぶ

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up