開發者中心

CDC 標準 (MMWR)

library(lubridate)

# Get current Epi Week (CDC)
epiweek(Sys.Date())

# For a specific date
epiweek(as.Date("2024-01-01"))

ISO 8601 標準

library(lubridate)

# Get current ISO Week
isoweek(Sys.Date())

CDC 標準 (MMWR)

# pip install epiweeks
from epiweeks import Week, Year
from datetime import date

# Current week
week = Week.fromdate(date.today())
print(f"EW {week.week} of {week.year}")

# Iterate over weeks
for week in Year(2024).iterweeks():
    print(week.startdate(), week.enddate())

ISO 8601 標準

-- Return week in 'IYYY-IW' format (e.g. 2024-01)
SELECT TO_CHAR(CURRENT_DATE, 'IYYY-IW');

-- Week number only
SELECT EXTRACT('week' FROM CURRENT_DATE);

ISO 8601 標準

=ISOWEEKNUM(A1)

使用標準 ISOWEEKNUM 函數。