DB2常用函數(shù)詳解之日期時(shí)間函數(shù)大全
以下的文章主要描述的是DB2常用函數(shù)詳解之日期時(shí)間函數(shù)，如果你是DB2常用函數(shù)詳解之日期時(shí)間函數(shù)的熱捧者。那么下面的文章對(duì)于你而言一定很有意義，以下就是相關(guān)內(nèi)容的詳細(xì)介紹。
文章分類:數(shù)據(jù)庫(kù) 關(guān)鍵字: db2，函數(shù)，日期時(shí)間
DB2常用函數(shù)之：DATE函數(shù)
語(yǔ)法：DATE(ARG)
DATE函數(shù)返回一個(gè)日期、時(shí)間戳、日期字符串、時(shí)間戳字符串中的日期。
Sql代碼
eg:
SELECT DATE('2005-06-12 16.24.18.121212') FROM TEST
eg:
SELECT DATE('2005-06-12 16.24.18.121212') FROM TEST
DB2常用函數(shù)之：TIME函數(shù)
語(yǔ)法：TIME(ARG)
TIME函數(shù)返回一個(gè)時(shí)間、時(shí)間戳或一個(gè)時(shí)間、時(shí)間戳字符串參數(shù)的時(shí)間。
Sql代碼
eg:
SELECT TIME('2005-06-12 16.24.18.121212') FROM TEST
eg:
SELECT TIME('2005-06-12 16.24.18.121212') FROM TEST
DB2常用函數(shù)之：TIMESTAMP函數(shù)
語(yǔ)法：TIMESTAMP(EXPRES1[,EXPRES2])
TIMESTAMP函數(shù)返回一個(gè)或兩個(gè)參數(shù)中的時(shí)間戳。
Sql代碼
eg:
SELECT TIMESTAMP('2005-06-12 16.24.18.121212') FROM TEST
eg:
SELECT TIMESTAMP('2005-06-12 16.24.18.121212') FROM TEST
注：如果只有一個(gè)參數(shù)，這個(gè)參數(shù)必須是一個(gè)時(shí)間戳或一個(gè)時(shí)間戳字符串；如果有兩個(gè)參數(shù)，***個(gè)參數(shù)必須是一個(gè)日期或日期字符串，第二個(gè)參數(shù)必須是一個(gè)時(shí)間或時(shí)間戳字符串。
DB2常用函數(shù)之：YEAR函數(shù)
語(yǔ)法：YEAR(ARG)
YEAR函數(shù)返回一個(gè)日期、時(shí)間戳、日期字符串、時(shí)間戳字符串的年部分。
Sql代碼
eg:
SELECT YEAR('2005-06-12') FROM TEST
eg:
SELECT YEAR('2005-06-12') FROM TEST
MONTH函數(shù)
語(yǔ)法：MONTH(ARG)
DB2常用函數(shù)之：MONTH函數(shù)返回一個(gè)日期、時(shí)間戳、日期字符串、時(shí)間戳字符串的月部分。
Sql代碼
eg:
SELECT MONTH('2005-06-12') FROM TEST
eg:
SELECT MONTH('2005-06-12') FROM TEST
QUARTER函數(shù)
語(yǔ)法：QUARTER(ARG)
QUARTER函數(shù)返回一個(gè)日期、時(shí)間戳、日期字符串、時(shí)間戳字符串的季度部分。
Sql代碼
eg:
SELECT QUARTER(CURRENT DATE) FROM TEST
eg:
SELECT QUARTER(CURRENT DATE) FROM TEST
WEEK函數(shù)
語(yǔ)法：WEEK(ARG)
WEEK函數(shù)返回一個(gè)日期、時(shí)間戳、日期字符串、時(shí)間戳字符串的星期部分。
Sql代碼
eg:
SELECT WEEK(CURRENT DATE) FROM TEST
eg:
SELECT WEEK(CURRENT DATE) FROM TEST
DB2常用函數(shù)之：DAY函數(shù)
語(yǔ)法：DAY(ARG)
DAY函數(shù)返回一個(gè)日期、時(shí)間戳、日期字符串、時(shí)間戳字符串的日部分。
Sql代碼
eg:
SELECT DAY(CURRENT DATE) FROM TEST
eg:
SELECT DAY(CURRENT DATE) FROM TEST
HOUR函數(shù)
語(yǔ)法：HOUR(ARG)
HOUR函數(shù)返回一個(gè)日期、時(shí)間戳、日期字符串、時(shí)間戳字符串的小時(shí)部分。 #p#
Sql代碼
eg:
SELECT HOUR(CURRENT TIME) FROM TEST
eg:
SELECT HOUR(CURRENT TIME) FROM TEST
MINUTE函數(shù)
語(yǔ)法：MINUTE(ARG)
MINUTE函數(shù)返回一個(gè)日期、時(shí)間戳、日期字符串、時(shí)間戳字符串的分鐘部分。
Sql代碼
eg:
SELECT MINUTE(CURRENT TIME) FROM TEST
eg:
SELECT MINUTE(CURRENT TIME) FROM TEST
SECOND函數(shù)
語(yǔ)法：SECOND(ARG)
SECOND函數(shù)返回一個(gè)日期、時(shí)間戳、日期字符串、時(shí)間戳字符串的秒部分。
Sql代碼
eg:
SELECT SECOND(CURRENT TIME) FROM TEST
eg:
SELECT SECOND(CURRENT TIME) FROM TEST
DB2常用函數(shù)之：DAYS函數(shù)
語(yǔ)法：DAYS(ARG)
DAYS函數(shù)返回一個(gè)日期、時(shí)間戳、日期字符串、時(shí)間戳字符串的日期整數(shù)表示法，從0001-01-01以來(lái)的天數(shù)。
Sql代碼
eg:
SELECT DAYS(CURRENT TIME) FROM TEST
eg:
SELECT DAYS(CURRENT TIME) FROM TEST
DAYOFYEAR函數(shù)
語(yǔ)法：DAYOFYEAR(ARG)
DAYOFYEAR函數(shù)返回一個(gè)日期、時(shí)間戳、日期字符串、時(shí)間戳字符串在年內(nèi)的天值。
Sql代碼
eg:
SELECT DAYOFYEAR(CURRENT DATE) FROM TEST
eg:
SELECT DAYOFYEAR(CURRENT DATE) FROM TEST
DAYOFWEEK函數(shù)
語(yǔ)法：DAYOFWEEK(ARG)
DAYOFWEEK函數(shù)返回一個(gè)日期、時(shí)間戳、日期字符串、時(shí)間戳字符串在周內(nèi)的天值（從周日開(kāi)始 1 到 7 ）。
Sql代碼
eg:
SELECT DAYOFWEEK(CURRENT DATE) FROM TEST
eg:
SELECT DAYOFWEEK(CURRENT DATE) FROM TEST
DAYOFWEEK_ISO函數(shù)
語(yǔ)法：DAYOFWEEK_ISO(ARG)
DAYOFWEEK_ISO函數(shù)返回一個(gè)日期、時(shí)間戳、日期字符串、時(shí)間戳字符串在周內(nèi)的天值（從周一開(kāi)始 1 到 7 ）。
Sql代碼
eg:
SELECT DAYOFWEEK_ISO(CURRENT DATE) FROM TEST
eg:
SELECT DAYOFWEEK_ISO(CURRENT DATE) FROM TEST
DB2常用函數(shù)之：DAYNAME函數(shù)
語(yǔ)法：DAYNAME(ARG)
DAYNAME函數(shù)返回一個(gè)日期、時(shí)間戳、日期字符串、時(shí)間戳字符串是星期幾。
Sql代碼
eg:
SELECT DAYNAME(CURRENT DATE) FROM TEST
eg:
SELECT DAYNAME(CURRENT DATE) FROM TEST
MONTHNAME函數(shù)
語(yǔ)法：MONTHNAME(ARG)
MONTHNAME函數(shù)返回一個(gè)日期、時(shí)間戳、日期字符串、時(shí)間戳字符串的月份名。
Sql代碼
eg:
SELECT MONTHNAME(CURRENT DATE) FROM TEST
eg:
SELECT MONTHNAME(CURRENT DATE) FROM TEST
MIDNIGHT_SECONDS函數(shù)
語(yǔ)法：MIDNIGHT_SECONDS(ARG)
DB2常用函數(shù)之：MIDNIGHT_SECONDS函數(shù)返回午夜和參數(shù)指定的時(shí)間值之間的秒數(shù)，用范圍再 0 到 86400 之間的整數(shù)值表示。
Sql代碼
eg:
SELECT MIDNIGHT_SECONDS(CURRENT TIME) FROM TEST
