Jeans & Development コンピューターのことなどを綴ったメモ (旧：目から鱗 w/SQLite)

6.3.4. 日付と時刻関数

すべて実装終了

ADDDATE(date,INTERVAL expr type) , ADDDATE(expr,days)

ADDTIME(expr,expr2)

CURDATE()

CURRENT_DATE , CURRENT_DATE()

CURTIME()

CURRENT_TIME , CURRENT_TIME()

CURRENT_TIMESTAMP , CURRENT_TIMESTAMP()

DATE(expr)
SQLite標準実装

DATEDIFF(expr,expr2)

DATE_ADD(date,INTERVAL expr type) , DATE_SUB(date,INTERVAL expr type)

DATE_FORMAT(date,format)

DAY(date)

DAYNAME(date)

DAYOFMONTH(date)

DAYOFWEEK(date)

DAYOFYEAR(date)

EXTRACT(type FROM date)

FROM_DAYS(N)

FROM_UNIXTIME(unix_timestamp) , FROM_UNIXTIME(unix_timestamp,format)

GET_FORMAT(DATE | TIME | TIMESTAMP, 'EUR' | 'USA' | 'JIS' | 'ISO' | 'INTERNAL')

HOUR(time)

LAST_DAY(date)

LOCALTIME , LOCALTIME()

LOCALTIMESTAMP , LOCALTIMESTAMP()

MAKEDATE(year,dayofyear)

MAKETIME(hour,minute,second)

MICROSECOND(expr)

MINUTE(time)

MONTH(date)

MONTHNAME(date)

NOW()

PERIOD_ADD(P,N)

PERIOD_DIFF(P1,P2)

QUARTER(date)

SECOND(time)

SEC_TO_TIME(seconds)

STR_TO_DATE(str,format)

SUBDATE(date,INTERVAL expr type) , SUBDATE(expr,days)

SUBTIME(expr,expr2)

SYSDATE()

TIME(expr)
SQLite標準実装

TIMEDIFF(expr,expr2)

TIMESTAMP(expr) , TIMESTAMP(expr,expr2)

TO_DAYS(date)

UNIX_TIMESTAMP() , UNIX_TIMESTAMP(date)

UTC_DATE , UTC_DATE()

UTC_TIME , UTC_TIME()

UTC_TIMESTAMP , UTC_TIMESTAMP()

WEEK(date [,mode])

WEEKDAY(date)

WEEKOFYEAR(date)

YEAR(date)

YEARWEEK(date) , YEARWEEK(date,start)