DB2 요일 구하는 SQL

SELECT DAYOFWEEK(TIMESTAMP_FORMAT(:as_date, 'YYYY-MM-DD')) AS YOIL FROM SYSIBM.SYSDUMMY1


SELECT DAYOFWEEK( TO_DATE('20120213', 'YYYYMMDD') ) AS YOIL FROM SYSIBM.SYSDUMMY1 WITH UR;