日付関数

日付関数	コメント
ADD_MONTHS	ADD_MONTHS
年	AGE
タイムゾーン	タイムゾーン
カレンダー月	CALENDAR_MONTH
カレンダー四半期	CALENDAR_QUARTER
暦年	CALENDAR_YEAR
クロックミリス	CLOCK_MILLIS
時計STR	CLOCK_STR
CLOCK_TIMESTAMP	CLOCK_TIMESTAMP
CURRENT_DATE	CURRENT_DATE、
CURRENT_TIME	CURRENT_TIME、
CURRENT_TIMESTAMP	CURRENT_TIMESTAMP、
DATE	日付
DATEADD	DATEADD
DATE_ADD	DATE_ADD
DATE_ADD_MILLIS	DATE_ADD_MILLIS
DATE_ADD_STR	DATE_ADD_STR
DATEDIFF	DATEDIFF
DATE_DIFF	DATEDIFFを参照してください。
DATE_DIFF_MILLIS	DATE_DIFF_MILLIS
DATE_DIFF_STR	DATE_DIFF_STR
DATENAME	DATENAME
DATEPART	DATEPART
DATE_PART	DATE_PART
DATE_PART_MILLIS	DATE_PART_MILLIS
DATE_PART_STR	DATE_PART_STR
DATETRUNC	DATETRUNC
DATE_TRUNC	DATE_TRUNC
DATE_TRUNC_MILLIS	DATE_TRUNC_MILLIS
DATE_TRUNC_STR	DATE_TRUNC_STR
DATE_SUB	DATE_SUB
DAY	日、月、年、
DAYNAME	DAYNAME
DAYOFMONTH	DAYOFMONTH
DAYOFWEEK	DAYOFWEEK
DAYOFWEEK_ISO	DAYOFWEEK_ISO
DAYOFYEAR	DAYOFYEAR
DAYS	日
DAYS_BETWEEN	DAYS_BETWEEN
DAYS_IN_MONTH	DAY_IN_MONTH
DAY_IN_WEEK	DAY_IN_WEEK
DAY_IN_YEAR	DAY_IN_YEAR
DAY_ONLY	DAY_ONLY
DBTIMEZONE	DBTIMEZONE
EXTRACT	EXTRACTを参照してください
EXTRACTDAY	抜粋
EXTRACTDOW	EXTRACTDOW
EXTRACTDOY	EXTRACTDOY
EXTRACTEPOCH	EXTRACTEPOCH
EXTRACTHOUR	EXTRACTHOUR
EXTRACTMICROSECOND	EXTRACTMICROSECOND
EXTRACTMILLISECOND	EXTRACTMILLISECOND
EXTRACTMINUTE	EXTRACTMINUTE
EXTRACTMONTH	EXTRACTMONTH
EXTRACTQUARTER	EXTRACTQUARTER
EXTRACTSECOND	EXTRACTSECOND
EXTRACTWEEK	EXTRACTWEEK
EXTRACTYEAR	EXTRACTYEAR
FISCAL_MONTH	FISCAL_MONTH
FISCAL_QUARTER	FISCAL_QUARTER
会計年度	FISCAL_YEAR
フラクショナルセコンド	FRACTIONALSECONDS
FROM_UNIXTIME	FROM_UNIXTIME
GETUTCDATE	GETUTCDATE
HOUR	時間
HOUR_IN_DAY	HOUR_IN_DAY
ISFINITE	ISFINITE
JULIAN_DAY	JULIAN_DAY
LAST_DAY	LAST_DAY
現地時間	LOCALTIME
LOCALTIMESTAMP	LOCALTIMESTAMP
MAXDATETIME	MAXDATETIME
MICROSECOND	マイクロ秒
MIDNIGHT_SECONDS	MIDNIGHT_SECONDS
ミリス	ミリス
MILLIS_TO_STR	MILLIS_TO_STR
MILLIS_TO_UTC	MILLIS_TO_UTC
MINDATETIME	MINDATETIME
MINUTE	MAXDATETIME
MONTH	日、月、年、
MONTHNAME	月の名前
MONTHS_BETWEEN	MONTHS_BETWEEN、
NEW_TIME	NEW_TIME
NEXT_DAY	NEXT_DAY
NOW	今
NOW_MILLIS	NOW_MILLIS
NOW_STR	NOW_STR
NUMTODSINTERVAL	NUMTODSINTERVAL、
NUMTOYMINTERVAL	NUMTOYMINTERVAL、
QUARTER	QUARTER
ROUND	ラウンド
SECOND	2番目
STATEMENT_TIMESTAMP
STR_TO_MILLIS	STR_TO_MILLIS
STR_TO_UTC	STR_TO_UTC
STR_TO_ZONE_NAME	STR_TO_ZONE_NAME
SYSDATE	SYSDATE
TIME	時間
TIME_SLICE	TIME_SLICE
TIMEOFDAY	TIMEOFDAY
TIMESTAMP_ROUND	TIMESTAMP_ROUND
TIMESTAMP_TRUNC	TIMESTAMP_TRUNC
TIMESTAMPADD	TIMESTAMPADD
TIMESTAMPDIFF	TIMESTAMPDIFF
TOTALOFFSETMINUTES	TOTALOFFSETMINUTES
合計	合計秒数
TRANSACTION_TIMESTAMP	TRANSACTION_TIMESTAMP
TZ_OFFSET	TZ_OFFSET、
TZCONVERTOR	TZCONVERTOR、
UNIX_TIMESTAMP	UNIX_TIMESTAMP
UTC_TO_TIMESTAMP	UTC_TO_TIMESTAMP、
WEEK	週
WEEK_IN_MONTH	WEEK_IN_MONTH
WEEK_IN_YEAR	WEEK_IN_YEAR
WEEK_ISO	WEEK_ISO
YEAR	日、月、年、
YEAR_ISO	YEAR_ISO