[DATABASE/DB2] WEEK_ISO 함수 : ISO 주차 구하기

icodebroker DB2 2024-06-18

■ WEEK_ISO 함수를 사용해 ISO 주차를 구하는 방법을 보여준다.

▶ 예제 코드 (SQL)


SELECT WEEK_ISO(CURRENT DATE)
FROM   SYSIBM.SYSDUMMY1
WITH UR;

SELECT WEEK_ISO('1997-12-28')
FROM   SYSIBM.SYSDUMMY1
WITH UR;

SELECT WEEK_ISO(CURRENT DATE)

FROM SYSIBM.SYSDUMMY1

WITH UR;

SELECT WEEK_ISO('1997-12-28')

FROM SYSIBM.SYSDUMMY1

WITH UR;

Post Views: 10