日期格式:DB2

Question

我知道当前日期函数给出了今天的日期当前日期='2022-06-29'如果我想获得当前月份的第一个日期和最后一个日期，我如何在DB2中做到这一点?

cast(JOB.FOMDATE as DATE), cast(JOB.TOMDATE as DATE)) OVERLAPS (cast(***'2022-01-01'*** as DATE), cast(***'2022-01-31'*** as DATE)) 

Thanks very much

Answer 1

查看以下内置函数:
FIRST_DAY
LAST_DAY

SELECT 
D
, FIRST_DAY (D)                     AS D_FIRST
, D - DAY (D) + 1                   AS D_FIRST_ALT
, LAST_DAY (D)                      AS D_LAST
, D - (DAY (D) - 1) + 1 MONTH - 1   AS D_LAST_ALT
FROM (VALUES CURRENT DATE) T (D)