DB2
涓湁鍏虫棩鏈熷拰鏃堕棿鐨勫嚱鏁帮紝鍙婂簲鐢?/p>
DAYNAME
杩斿洖涓�涓ぇ灏忓啓娣峰悎鐨勫瓧绗︿覆锛?/p>
瀵逛簬鍙傛暟鐨勬棩閮ㄥ垎锛岀敤鏄熸湡琛ㄧず杩欎竴澶╃殑
鍚嶇О锛堜緥濡傦紝
Friday
锛?/p>
銆?/p>
DAYOFWEEK
杩斿洖鍙傛暟涓殑鏄熸湡鍑狅紝
鐢ㄨ寖鍥村湪
1-7
鐨勬暣鏁板�艰〃绀猴紝
鍏朵腑
1
浠ｈ〃鏄熸湡鏃ャ�?/p>
DAYOFWEEK_ISO
杩斿洖鍙傛暟涓殑鏄熸湡鍑狅紝鐢ㄨ寖鍥村湪
1-7
鐨勬暣鏁板�艰〃绀猴紝鍏朵腑
1
浠ｈ〃鏄熸湡
涓�銆?/p>
DAYOFYEAR
杩斿洖鍙傛暟涓竴骞翠腑鐨勭鍑犲ぉ锛岀敤鑼冨洿鍦?/p>
1-366
鐨勬暣鏁板�艰〃绀恒�?/p>
DAYS
杩斿洖鏃ユ湡鐨勬暣鏁拌〃绀恒�?/p>
JULIAN_DAY
杩斿洖浠庡叕鍏冨墠
4712
骞?/p>
1
鏈?/p>
1
鏃ワ紙鍎掔暐鏃ュ巻鐨勫紑濮嬫棩鏈燂級鍒板弬鏁颁腑
鎸囧畾鏃ユ湡鍊间箣闂寸殑澶╂暟锛岀敤鏁存暟鍊艰〃绀恒�?/p>
MIDNIGHT_SECONDS
杩斿洖鍗堝鍜屽弬鏁颁腑鎸囧畾鐨勬椂闂村�间箣闂寸殑绉掓暟锛?/p>
鐢ㄨ寖鍥村湪
0
鍒?/p>
86400
涔嬮棿鐨勬暣鏁板�艰〃绀恒�?/p>
MONTHNAME
瀵逛簬鍙傛暟鐨勬湀閮ㄥ垎鐨勬湀浠斤紝
杩斿洖涓�涓ぇ灏忓啓娣峰悎鐨勫瓧绗︿覆
锛堜緥濡傦紝
January
锛?/p>
銆?/p>
TIMESTAMP_ISO
鏍规嵁鏃ユ湡銆佹椂闂存垨鏃堕棿鎴宠鍙傛暟鑰岃繑鍥炰竴涓椂闂存埑璁板�笺�?/p>
TIMESTAMP_FORMAT
浠庡凡浣跨敤瀛楃妯℃澘瑙ｉ噴鐨勫瓧绗︿覆杩斿洖鏃堕棿鎴宠銆?/p>
TIMESTAMPDIFF
鏍规嵁涓や釜鏃堕棿鎴宠涔嬮棿鐨勬椂宸紝杩斿洖鐢辩涓�涓弬鏁板畾涔夌殑绫诲瀷琛ㄧず
鐨勪及璁℃椂宸�?/p>
TO_CHAR
杩斿洖宸茬敤瀛楃妯℃澘杩涜鏍煎紡鍖栫殑鏃堕棿鎴宠鐨勫瓧绗﹁〃绀恒�?/p>
TO_CHAR
鏄?/p>
VARCHAR_FORMAT
鐨勫悓涔夎瘝銆?/p>
TO_DATE
浠庡凡浣跨敤瀛楃妯℃澘瑙ｉ噴杩囩殑瀛楃涓茶繑鍥炴椂闂存埑璁般�?/p>
TO_DATE
鏄?/p>
TIMESTAMP_FORMAT
鐨勫悓涔夎瘝銆?/p>
WEEK
杩斿洖鍙傛暟涓竴骞寸殑绗嚑鍛紝鐢ㄨ寖鍥村湪
1-54
鐨勬暣鏁板�艰〃绀恒�備互鏄熸湡
鏃ヤ綔涓轰竴鍛ㄧ殑寮�濮嬨�?/p>
WEEK_ISO
杩斿洖鍙傛暟涓竴骞寸殑绗嚑鍛紝鐢ㄨ寖鍥村湪
1-53
鐨勬暣鏁板�艰〃绀恒�?/p>
瑕佷娇褰撳墠鏃堕棿鎴栧綋鍓嶆椂闂存埑璁拌皟鏁村埌
GMT/CUT
锛?/p>
鍒欐妸褰撳墠鐨勬椂闂存垨鏃堕棿鎴宠鍑忓幓褰撳墠鏃跺尯
瀵勫瓨鍣細
current time - current timezone
current timestamp - current timezone
缁欏畾浜嗘棩鏈熴�?/p>
鏃堕棿鎴栨椂闂存埑璁帮紝
鍒欎娇鐢ㄩ�傚綋鐨勫嚱鏁板彲浠ュ崟鐙娊鍙栧嚭
锛堝鏋滈�傜敤鐨勮瘽锛?/p>
骞淬�?/p>
鏈堛�?/p>
鏃ャ�佹椂銆佸垎銆佺鍙婂井绉掑悇閮ㄥ垎锛?/p>
YEAR (current timestamp)
MONTH (current timestamp)
DAY (current timestamp)
HOUR (current timestamp)
MINUTE (current timestamp)
SECOND (current timestamp)
MICROSECOND (current timestamp)
鍥犱负娌℃湁鏇村ソ鐨勬湳璇紝鎵�浠ユ偍杩樺彲浠ヤ娇鐢ㄨ嫳璇潵鎵ц鏃ユ湡鍜屾椂闂磋绠楋細
current date + 1 YEAR
current date + 3 YEARS + 2 MONTHS + 15 DAYS