AddNanoseconds( expression , number )
|
( expression ) + INTERVAL
|
AddMicroseconds( expression , number )
|
( expression ) + INTERVAL
|
AddMilliseconds( expression , number )
|
( expression ) + INTERVAL
|
AddSeconds( expression , number )
|
( expression ) + INTERVAL
|
AddMinutes( expression , number )
|
( expression ) + INTERVAL
|
AddHours( expression , number )
|
( expression ) + INTERVAL
|
AddDays( expression , number )
|
( expression ) + INTERVAL
|
AddMonths( expression , number )
|
( expression ) + INTERVAL
|
AddYears( expression , number )
|
( expression ) + INTERVAL
|
CreateDateTime( year , month , day , hour , minute , second )
|
TO_TIMESTAMP
|
CreateDateTimeOffset( year , month , day , hour , minute , second , tzoffset )
|
TO_TIMESTAMP_TZ
|
CreateTime( hour , minute , second )
|
Oracleでは時間リテラルがサポートされていません
|
CurrentDateTime()
|
LOCALTIMESTAMP
|
CurrentDateTimeOffset()
|
SYSTIMESTAMP
|
CurrentUtcDateTime()
|
SYS_EXTRACT_UTC
( LOCALTIMESTAMP )
|
Day( expression )
|
EXTRACT(DAY FROM expression )
|
DayOfYear( expression )
|
TO_NUMBER(TO_CHAR(CAST( expression AS TIMESTAMP), 'DDD'))
|
DiffNanoseconds( startExpression , endExpression )
|
EXTRACT および算術操作
|
DiffMilliseconds( startExpression , endExpression )
|
EXTRACT および算術操作
|
DiffMicroseconds( startExpression , endExpression )
|
EXTRACT および算術操作
|
DiffSeconds( startExpression , endExpression )
|
EXTRACT および算術操作
|
DiffMinutes( startExpression , endExpression )
|
EXTRACT および算術操作
|
DiffHours( startExpression , endExpression )
|
EXTRACT および算術操作
|
DiffDays( startExpression , endExpression )
|
EXTRACT および算術操作
|
DiffMonths( startExpression , endExpression )
|
EXTRACT および算術操作
|
DiffYears( startExpression , endExpression
)
|
EXTRACT および算術操作
|
比較演算子
(<, <=, >, >=, <>, !=)
|
<, <=, >, >=, <>, != 演算子
|
GetTotalOffsetMinutes ( datetimeoffset )
|
(EXTRACT(TIMEZONE_HOUR FROM ( expression ))) * 60 + EXTRACT (TIMEZONE_MINUTE FROM( expression ))
(複数の操作が必要です。)
|
Hour ( expression )
|
EXTRACT(HOUR FROM expression )
|
Millisecond( expression )
|
NVL(TO_NUMBER(SUBSTR(TO_CHAR(CAST( expression AS TIMESTAMP), 'DD-
MON-RR HH24:MI:SSXFF'), 20, 3)), 0)
|
Minute( expression )
|
EXTRACT(MINUTE FROM expression )
|
Month ( expression )
|
EXTRACT(MONTH FROM expression )
|
Second( expression )
|
EXTRACT (SECOND FROM expression )
|
TruncateDate( expression )
|
TRUNC( expression )
|
Year( expression )
|
EXTRACT(YEAR FROM expression )
|