[DATABASE/DB2] YEAR 함수 : 연도 구하기

■ YEAR 함수를 사용해 연도를 구하는 방법을 보여준다.

▶ 예제 코드 (SQL)


SELECT YEAR(CURRENT TIMESTAMP)
FROM   SYSIBM.SYSDUMMY1
WITH UR;

SELECT YEAR('2004-05-16')
FROM   SYSIBM.SYSDUMMY1
WITH UR;

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

SELECT YEAR(CURRENT TIMESTAMP)

FROM SYSIBM.SYSDUMMY1

WITH UR;

SELECT YEAR('2004-05-16')

FROM SYSIBM.SYSDUMMY1

WITH UR;

SELECT YEAR(CURRENT DATE)

FROM SYSIBM.SYSDUMMY1

WITH UR;