锘??xml version="1.0" encoding="utf-8" standalone="yes"?>
]]>
UTL_I18N.TRANSLITERATE (TO_MULTI_BYTE(NAME), 'KANA_HIRAGANA') NAME--鍗婅銈偪銈儕銉昏嫳鏁板瓧-->鍏ㄨ銇層倝銇嬨仾
, UTL_I18N.TRANSLITERATE (TO_MULTI_BYTE(KANA), 'KANA_FWKATAKANA') KANA--鍗婅銈偪銈儕-->鍏ㄨ銈偪銈儕
, UTL_I18N.TRANSLITERATE (TO_MULTI_BYTE(SEIKINAME), 'KANA_HIRAGANA') SEIKINAME--鍗婅銈偪銈儕-->鍏ㄨ銇層倝銇嬨仾
, UTL_I18N.TRANSLITERATE (TO_MULTI_BYTE(SEIKIKANA), 'HIRAGANA_HWKATAKANA') SEIKIKANA --鍏ㄨ銇層倝銇嬨仾銉匯偒銈褲偒銉?->鍗婅銈褲偒
, UTL_I18N.TRANSLITERATE (TO_MULTI_BYTE(ZYUSHO), 'KANA_HIRAGANA') ZYUSHO--鍗婅銈偪銈儕-->鍏ㄨ銇層倝銇嬨仾
1.ceil 錛堬級 /ceiling錛堬級 鍚戜笂鍙栨暣
ex錛?ceil錛?.2錛?= 2
2.floor 錛堬級 鍚戜笅鍙栨暣
ex錛?floor錛?.2錛?= 1
3.round錛堬級 鍥涜垗浜斿叆
榪欓噷鏄竴涓嬌鐢ㄦ棩鏈熷嚱鏁扮殑渚嬪瓙銆備笅闈㈢殑鏌ヨ閫夋嫨浜嗘墍鏈夎褰曪紝鍏禿ate_col鐨勫兼槸鍦ㄦ渶鍚?0澶╀互鍐咃細
mysql> SELECT something FROM table
WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) <= 30;
DAYOFWEEK(date)
榪斿洖鏃ユ湡date鐨勬槦鏈熺儲寮?1=鏄熸湡澶╋紝2=鏄熸湡涓, ……7=鏄熸湡鍏?銆傝繖浜涚儲寮曞煎搴斾簬ODBC鏍囧噯銆?nbsp;
mysql> select DAYOFWEEK('1998-02-03');
-> 3
WEEKDAY(date)
榪斿洖date鐨勬槦鏈熺儲寮?0=鏄熸湡涓錛?=鏄熸湡浜? ……6= 鏄熸湡澶?銆?nbsp;
mysql> select WEEKDAY('1997-10-04 22:23:00');
-> 5
mysql> select WEEKDAY('1997-11-05');
-> 2
DAYOFMONTH(date)
榪斿洖date鐨勬湀浠戒腑鏃ユ湡錛屽湪1鍒?1鑼冨洿鍐呫?nbsp;
mysql> select DAYOFMONTH('1998-02-03');
-> 3
DAYOFYEAR(date)
榪斿洖date鍦ㄤ竴騫翠腑鐨勬棩鏁? 鍦?鍒?66鑼冨洿鍐呫?nbsp;
mysql> select DAYOFYEAR('1998-02-03');
-> 34
MONTH(date)
榪斿洖date鐨勬湀浠斤紝鑼冨洿1鍒?2銆?nbsp;
mysql> select MONTH('1998-02-03');
-> 2
DAYNAME(date)
榪斿洖date鐨勬槦鏈熷悕瀛椼?nbsp;
mysql> select DAYNAME("1998-02-05");
-> 'Thursday'
MONTHNAME(date)
榪斿洖date鐨勬湀浠藉悕瀛椼?nbsp;
mysql> select MONTHNAME("1998-02-05");
-> 'February'
QUARTER(date)
榪斿洖date涓騫翠腑鐨勫搴︼紝鑼冨洿1鍒?銆?nbsp;
mysql> select QUARTER('98-04-01');
-> 2
WEEK(date)
WEEK(date,first)
瀵逛簬鏄熸湡澶╂槸涓鍛ㄧ殑絎竴澶╃殑鍦版柟錛屾湁涓涓崟涓弬鏁幫紝榪斿洖date鐨勫懆鏁幫紝鑼冨洿鍦?鍒?2銆?涓弬鏁板艦寮廤EEK()鍏佽
浣犳寚瀹氭槦鏈熸槸鍚﹀紑濮嬩簬鏄熸湡澶╂垨鏄熸湡涓銆傚鏋滅浜屼釜鍙傛暟鏄?錛屾槦鏈熶粠鏄熸湡澶╁紑濮嬶紝濡傛灉絎簩涓弬鏁版槸1錛?nbsp;
浠庢槦鏈熶竴寮濮嬨?nbsp;
mysql> select WEEK('1998-02-20');
-> 7
mysql> select WEEK('1998-02-20',0);
-> 7
mysql> select WEEK('1998-02-20',1);
-> 8
YEAR(date)
榪斿洖date鐨勫勾浠斤紝鑼冨洿鍦?000鍒?999銆?nbsp;
mysql> select YEAR('98-02-03');
-> 1998
HOUR(time)
榪斿洖time鐨勫皬鏃訛紝鑼冨洿鏄?鍒?3銆?nbsp;
mysql> select HOUR('10:05:03');
-> 10
MINUTE(time)
榪斿洖time鐨勫垎閽燂紝鑼冨洿鏄?鍒?9銆?nbsp;
mysql> select MINUTE('98-02-03 10:05:03');
-> 5
SECOND(time)
鍥炴潵time鐨勭鏁幫紝鑼冨洿鏄?鍒?9銆?nbsp;
mysql> select SECOND('10:05:03');
-> 3
PERIOD_ADD(P,N)
澧炲姞N涓湀鍒伴樁孌礟錛堜互鏍煎紡YYMM鎴朰YYYMM)銆備互鏍煎紡YYYYMM榪斿洖鍊箋傛敞鎰忛樁孌靛弬鏁癙涓嶆槸鏃ユ湡鍊箋?nbsp;
mysql> select PERIOD_ADD(9801,2);
-> 199803
PERIOD_DIFF(P1,P2)
榪斿洖鍦ㄦ椂鏈烶1鍜孭2涔嬮棿鏈堟暟錛孭1鍜孭2搴旇浠ユ牸寮廦YMM鎴朰YYYMM銆傛敞鎰忥紝鏃舵湡鍙傛暟P1鍜孭2涓嶆槸鏃ユ湡鍊箋?nbsp;
mysql> select PERIOD_DIFF(9802,199703);
-> 11
DATE_ADD(date,INTERVAL expr type)
DATE_SUB(date,INTERVAL expr type)
ADDDATE(date,INTERVAL expr type)
SUBDATE(date,INTERVAL expr type)
榪欎簺鍔熻兘鎵ц鏃ユ湡榪愮畻銆傚浜嶮ySQL 3.22錛屼粬浠槸鏂扮殑銆侫DDDATE()鍜孲UBDATE()鏄疍ATE_ADD()鍜孌ATE_SUB()鐨勫悓涔夎瘝銆?nbsp;
鍦∕ySQL 3.23涓紝浣犲彲浠ヤ嬌鐢?鍜?鑰屼笉鏄疍ATE_ADD()鍜孌ATE_SUB()銆傦紙瑙佷緥瀛愶級date鏄竴涓寚瀹氬紑濮嬫棩鏈熺殑
DATETIME鎴朌ATE鍊鹼紝expr鏄寚瀹氬姞鍒板紑濮嬫棩鏈熸垨浠庡紑濮嬫棩鏈熷噺鍘葷殑闂撮殧鍊間竴涓〃杈懼紡錛宔xpr鏄竴涓瓧絎︿覆錛涘畠鍙互浠?nbsp;
涓涓?#8220;-”寮濮嬭〃紺鴻礋闂撮殧銆倀ype鏄竴涓叧閿瘝錛屾寚鏄庤〃杈懼紡搴旇濡備綍琚В閲娿侲XTRACT(type FROM date)鍑芥暟浠庢棩鏈?nbsp;
涓繑鍥?#8220;type”闂撮殧銆備笅琛ㄦ樉紺轟簡type鍜宔xpr鍙傛暟鎬庢牱琚叧鑱旓細 type鍊?鍚箟 鏈熸湜鐨別xpr鏍煎紡
SECOND 縐?SECONDS
MINUTE 鍒嗛挓 MINUTES
HOUR 鏃墮棿 HOURS
DAY 澶?DAYS
MONTH 鏈?MONTHS
YEAR 騫?YEARS
MINUTE_SECOND 鍒嗛挓鍜岀 "MINUTES:SECONDS"
HOUR_MINUTE 灝忔椂鍜屽垎閽?"HOURS:MINUTES"
DAY_HOUR 澶╁拰灝忔椂 "DAYS HOURS"
YEAR_MONTH 騫村拰鏈?"YEARS-MONTHS"
HOUR_SECOND 灝忔椂, 鍒嗛挓錛?"HOURS:MINUTES:SECONDS"
DAY_MINUTE 澶? 灝忔椂, 鍒嗛挓 "DAYS HOURS:MINUTES"
DAY_SECOND 澶? 灝忔椂, 鍒嗛挓, 縐?"DAYS HOURS:MINUTES:SECONDS"
MySQL鍦╡xpr鏍煎紡涓厑璁鎬換浣曟爣鐐瑰垎闅旂銆傝〃紺烘樉紺虹殑鏄緩璁殑鍒嗛殧絎︺傚鏋渄ate鍙傛暟鏄竴涓狣ATE鍊煎茍涓斾綘鐨勮綆椾粎浠?nbsp;
鍖呭惈YEAR銆丮ONTH鍜孌AY閮ㄥ垎(鍗籌紝娌℃湁鏃墮棿閮ㄥ垎)錛岀粨鏋滄槸涓涓狣ATE鍊箋傚惁鍒欑粨鏋滄槸涓涓狣ATETIME鍊箋?/p>
mysql> SELECT "1997-12-31 23:59:59" + INTERVAL 1 SECOND;
-> 1998-01-01 00:00:00
mysql> SELECT INTERVAL 1 DAY + "1997-12-31";
-> 1998-01-01
mysql> SELECT "1998-01-01" - INTERVAL 1 SECOND;
-> 1997-12-31 23:59:59
mysql> SELECT DATE_ADD("1997-12-31 23:59:59",
INTERVAL 1 SECOND);
-> 1998-01-01 00:00:00
mysql> SELECT DATE_ADD("1997-12-31 23:59:59",
INTERVAL 1 DAY);
-> 1998-01-01 23:59:59
mysql> SELECT DATE_ADD("1997-12-31 23:59:59",
INTERVAL "1:1" MINUTE_SECOND);
-> 1998-01-01 00:01:00
mysql> SELECT DATE_SUB("1998-01-01 00:00:00",
INTERVAL "1 1:1:1" DAY_SECOND);
-> 1997-12-30 22:58:59
mysql> SELECT DATE_ADD("1998-01-01 00:00:00",
INTERVAL "-1 10" DAY_HOUR);
-> 1997-12-30 14:00:00
mysql> SELECT DATE_SUB("1998-01-02", INTERVAL 31 DAY);
-> 1997-12-02
mysql> SELECT EXTRACT(YEAR FROM "1999-07-02");
-> 1999
mysql> SELECT EXTRACT(YEAR_MONTH FROM "1999-07-02 01:02:03");
-> 199907
mysql> SELECT EXTRACT(DAY_MINUTE FROM "1999-07-02 01:02:03");
-> 20102
濡傛灉浣犳寚瀹氬お鐭殑闂撮殧鍊?涓嶅寘鎷瑃ype鍏抽敭璇嶆湡鏈涚殑闂撮殧閮ㄥ垎)錛孧ySQL鍋囪浣犵渷鎺変簡闂撮殧鍊肩殑鏈宸﹂潰閮ㄥ垎銆備緥濡傦紝
濡傛灉浣犳寚瀹氫竴涓猼ype鏄疍AY_SECOND錛屽糴xpr琚笇鏈涙湁澶┿佸皬鏃躲佸垎閽熷拰縐掗儴鍒嗐傚鏋滀綘璞?1:10"榪欐牱鎸囧畾鍊鹼紝
MySQL鍋囪鏃ュ瓙鍜屽皬鏃墮儴鍒嗘槸涓㈠け鐨勫茍涓斿間唬琛ㄥ垎閽熷拰縐掋傛崲鍙ヨ瘽璇達紝"1:10" DAY_SECOND浠ュ畠絳変環浜?1:10" MINUTE_SECOND
鐨勬柟寮忚В閲婏紝榪欏閭ySQL瑙i噴TIME鍊艱〃紺虹粡榪囩殑鏃墮棿鑰岄潪浣滀負涓澶╃殑鏃墮棿鐨勬柟寮忔湁浜屼箟鎬с傚鏋滀綘浣跨敤紜疄涓嶆紜殑鏃ユ湡錛?nbsp;
緇撴灉鏄疦ULL銆傚鏋滀綘澧炲姞MONTH銆乊EAR_MONTH鎴朰EAR騫朵笖緇撴灉鏃ユ湡澶т簬鏂版湀浠界殑鏈澶у煎ぉ鏁幫紝鏃ュ瓙鍦ㄦ柊鏈堢敤鏈澶х殑澶╄皟鏁淬?/p>
mysql> select DATE_ADD('1998-01-30', Interval 1 month);
-> 1998-02-28
娉ㄦ剰錛屼粠鍓嶉潰鐨勪緥瀛愪腑璇岻NTERVAL鍜宼ype鍏抽敭璇嶄笉鏄尯鍒嗗ぇ灝忓啓鐨勩?nbsp;
TO_DAYS(date)
緇欏嚭涓涓棩鏈焏ate錛岃繑鍥炰竴涓ぉ鏁?浠?騫寸殑澶╂暟)銆?nbsp;
mysql> select TO_DAYS(950501);
-> 728779
mysql> select TO_DAYS('1997-10-07');
-> 729669
TO_DAYS()涓嶆墦綆楃敤浜庝嬌鐢ㄦ牸鍒楅珮閲屽巻(1582)鍑虹幇鍓嶇殑鍊箋?/p>
FROM_DAYS(N)
緇欏嚭涓涓ぉ鏁癗錛岃繑鍥炰竴涓狣ATE鍊箋?nbsp;
mysql> select FROM_DAYS(729669);
-> '1997-10-07'
TO_DAYS()涓嶆墦綆楃敤浜庝嬌鐢ㄦ牸鍒楅珮閲屽巻(1582)鍑虹幇鍓嶇殑鍊箋?/p>
DATE_FORMAT(date,format)
鏍規嵁format瀛楃涓叉牸寮忓寲date鍊箋備笅鍒椾慨楗扮鍙互琚敤鍦╢ormat瀛楃涓蹭腑錛?%M 鏈堝悕瀛?January……December)
%W 鏄熸湡鍚嶅瓧(Sunday……Saturday)
%D 鏈夎嫳璇墠緙鐨勬湀浠界殑鏃ユ湡(1st, 2nd, 3rd, 絳夌瓑銆傦級
%Y 騫? 鏁板瓧, 4 浣?nbsp;
%y 騫? 鏁板瓧, 2 浣?nbsp;
%a 緙╁啓鐨勬槦鏈熷悕瀛?Sun……Sat)
%d 鏈堜喚涓殑澶╂暟, 鏁板瓧(00……31)
%e 鏈堜喚涓殑澶╂暟, 鏁板瓧(0……31)
%m 鏈? 鏁板瓧(01……12)
%c 鏈? 鏁板瓧(1……12)
%b 緙╁啓鐨勬湀浠藉悕瀛?Jan……Dec)
%j 涓騫翠腑鐨勫ぉ鏁?001……366)
%H 灝忔椂(00……23)
%k 灝忔椂(0……23)
%h 灝忔椂(01……12)
%I 灝忔椂(01……12)
%l 灝忔椂(1……12)
%i 鍒嗛挓, 鏁板瓧(00……59)
%r 鏃墮棿,12 灝忔椂(hh:mm:ss [AP]M)
%T 鏃墮棿,24 灝忔椂(hh:mm:ss)
%S 縐?00……59)
%s 縐?00……59)
%p AM鎴朠M
%w 涓涓槦鏈熶腑鐨勫ぉ鏁?0=Sunday ……6=Saturday 錛?nbsp;
%U 鏄熸湡(0……52), 榪欓噷鏄熸湡澶╂槸鏄熸湡鐨勭涓澶?nbsp;
%u 鏄熸湡(0……52), 榪欓噷鏄熸湡涓鏄槦鏈熺殑絎竴澶?nbsp;
%% 涓涓枃瀛?#8220;%”銆?/p>
鎵鏈夌殑鍏朵粬瀛楃涓嶅仛瑙i噴琚鍒跺埌緇撴灉涓?/p>
mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
-> 'Saturday October 1997'
mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s');
-> '22:23:00'
mysql> select DATE_FORMAT('1997-10-04 22:23:00',
'%D %y %a %d %m %b %j');
-> '4th 97 Sat 04 10 Oct 277'
mysql> select DATE_FORMAT('1997-10-04 22:23:00',
'%H %k %I %r %T %S %w');
-> '22 22 10 10:23:00 PM 22:23:00 00 6'
MySQL3.23涓紝鍦ㄦ牸寮忎慨楗扮瀛楃鍓嶉渶瑕?銆傚湪MySQL鏇存棭鐨勭増鏈腑錛?鏄彲閫夌殑銆?/p>
TIME_FORMAT(time,format)
榪欒薄涓婇潰鐨凞ATE_FORMAT()鍑芥暟涓鏍蜂嬌鐢紝浣嗘槸format瀛楃涓插彧鑳藉寘鍚鐞嗗皬鏃躲佸垎閽熷拰縐掔殑閭d簺鏍煎紡淇グ絎︺?nbsp;
鍏朵粬淇グ絎︿駭鐢熶竴涓狽ULL鍊兼垨0銆?nbsp;
CURDATE()
CURRENT_DATE
浠?YYYY-MM-DD'鎴朰YYYMMDD鏍煎紡榪斿洖浠婂ぉ鏃ユ湡鍊鹼紝鍙栧喅浜庡嚱鏁版槸鍦ㄤ竴涓瓧絎︿覆榪樻槸鏁板瓧涓婁笅鏂囪浣跨敤銆?nbsp;
mysql> select CURDATE();
-> '1997-12-15'
mysql> select CURDATE() + 0;
-> 19971215
CURTIME()
CURRENT_TIME
浠?HH:MM:SS'鎴朒HMMSS鏍煎紡榪斿洖褰撳墠鏃墮棿鍊鹼紝鍙栧喅浜庡嚱鏁版槸鍦ㄤ竴涓瓧絎︿覆榪樻槸鍦ㄦ暟瀛楃殑涓婁笅鏂囪浣跨敤銆?nbsp;
mysql> select CURTIME();
-> '23:50:26'
mysql> select CURTIME() + 0;
-> 235026
NOW()
SYSDATE()
CURRENT_TIMESTAMP
浠?YYYY-MM-DD HH:MM:SS'鎴朰YYYMMDDHHMMSS鏍煎紡榪斿洖褰撳墠鐨勬棩鏈熷拰鏃墮棿錛屽彇鍐充簬鍑芥暟鏄湪涓涓瓧絎︿覆榪樻槸鍦ㄦ暟瀛楃殑
涓婁笅鏂囪浣跨敤銆?nbsp;
mysql> select NOW();
-> '1997-12-15 23:50:26'
mysql> select NOW() + 0;
-> 19971215235026
UNIX_TIMESTAMP()
UNIX_TIMESTAMP(date)
濡傛灉娌℃湁鍙傛暟璋冪敤錛岃繑鍥炰竴涓猆nix鏃墮棿鎴寵(浠?1970-01-01 00:00:00'GMT寮濮嬬殑縐掓暟)銆傚鏋淯NIX_TIMESTAMP()鐢ㄤ竴
涓猟ate鍙傛暟琚皟鐢紝瀹冭繑鍥炰粠'1970-01-01 00:00:00' GMT寮濮嬬殑縐掓暟鍊箋俤ate鍙互鏄竴涓狣ATE瀛楃涓層佷竴涓狣ATETIME
瀛楃涓層佷竴涓猅IMESTAMP鎴栦互YYMMDD鎴朰YYYMMDD鏍煎紡鐨勬湰鍦版椂闂寸殑涓涓暟瀛椼?nbsp;
mysql> select UNIX_TIMESTAMP();
-> 882226357
mysql> select UNIX_TIMESTAMP('1997-10-04 22:23:00');
-> 875996580
褰揢NIX_TIMESTAMP琚敤浜庝竴涓猅IMESTAMP鍒楋紝鍑芥暟灝嗙洿鎺ユ帴鍙楀鹼紝娌℃湁闅愬惈鐨?#8220;string-to-unix-timestamp”鍙樻崲銆?/p>
FROM_UNIXTIME(unix_timestamp)
浠?YYYY-MM-DD HH:MM:SS'鎴朰YYYMMDDHHMMSS鏍煎紡榪斿洖unix_timestamp鍙傛暟鎵琛ㄧず鐨勫鹼紝鍙栧喅浜庡嚱鏁版槸鍦ㄤ竴涓瓧絎︿覆
榪樻槸鎴栨暟瀛椾笂涓嬫枃涓浣跨敤銆?nbsp;
mysql> select FROM_UNIXTIME(875996580);
-> '1997-10-04 22:23:00'
mysql> select FROM_UNIXTIME(875996580) + 0;
-> 19971004222300
FROM_UNIXTIME(unix_timestamp,format)
榪斿洖琛ㄧず Unix 鏃墮棿鏍囪鐨勪竴涓瓧絎︿覆錛屾牴鎹甪ormat瀛楃涓叉牸寮忓寲銆俧ormat鍙互鍖呭惈涓嶥ATE_FORMAT()鍑芥暟鍒楀嚭鐨勬潯
鐩悓鏍風殑淇グ絎︺?nbsp;
mysql> select FROM_UNIXTIME(UNIX_TIMESTAMP(),
'%Y %D %M %h:%i:%s %x');
-> '1997 23rd December 03:43:30 x'
SEC_TO_TIME(seconds)
榪斿洖seconds鍙傛暟錛屽彉鎹㈡垚灝忔椂銆佸垎閽熷拰縐掞紝鍊間互'HH:MM:SS'鎴朒HMMSS鏍煎紡鍖栵紝鍙栧喅浜庡嚱鏁版槸鍦ㄤ竴涓瓧絎︿覆榪樻槸鍦ㄦ暟瀛?nbsp;
涓婁笅鏂囦腑琚嬌鐢ㄣ?nbsp;
mysql> select SEC_TO_TIME(2378);
-> '00:39:38'
mysql> select SEC_TO_TIME(2378) + 0;
-> 3938
TIME_TO_SEC(time)
榪斿洖time鍙傛暟錛岃漿鎹㈡垚縐掋?nbsp;
mysql> select TIME_TO_SEC('22:23:00');
-> 80580
mysql> select TIME_TO_SEC('00:39:38');
-> 2378
DATE_FORMAT(date,format)
鏍規嵁format瀛楃涓叉牸寮忓寲date鍊箋備笅鍒椾慨楗扮鍙互琚敤鍦╢ormat瀛楃涓蹭腑錛?%M 鏈堝悕瀛?January……December)
%W 鏄熸湡鍚嶅瓧(Sunday……Saturday)
%D 鏈夎嫳璇墠緙鐨勬湀浠界殑鏃ユ湡(1st, 2nd, 3rd, 絳夌瓑銆傦級
%Y 騫? 鏁板瓧, 4 浣?nbsp;
%y 騫? 鏁板瓧, 2 浣?nbsp;
%a 緙╁啓鐨勬槦鏈熷悕瀛?Sun……Sat)
%d 鏈堜喚涓殑澶╂暟, 鏁板瓧(00……31)
%e 鏈堜喚涓殑澶╂暟, 鏁板瓧(0……31)
%m 鏈? 鏁板瓧(01……12)
%c 鏈? 鏁板瓧(1……12)
%b 緙╁啓鐨勬湀浠藉悕瀛?Jan……Dec)
%j 涓騫翠腑鐨勫ぉ鏁?001……366)
%H 灝忔椂(00……23)
%k 灝忔椂(0……23)
%h 灝忔椂(01……12)
%I 灝忔椂(01……12)
%l 灝忔椂(1……12)
%i 鍒嗛挓, 鏁板瓧(00……59)
%r 鏃墮棿,12 灝忔椂(hh:mm:ss [AP]M)
%T 鏃墮棿,24 灝忔椂(hh:mm:ss)
%S 縐?00……59)
%s 縐?00……59)
%p AM鎴朠M
%w 涓涓槦鏈熶腑鐨勫ぉ鏁?0=Sunday ……6=Saturday 錛?nbsp;
%U 鏄熸湡(0……52), 榪欓噷鏄熸湡澶╂槸鏄熸湡鐨勭涓澶?nbsp;
%u 鏄熸湡(0……52), 榪欓噷鏄熸湡涓鏄槦鏈熺殑絎竴澶?nbsp;
%% 涓涓枃瀛?#8220;%”銆?鎵鏈夌殑鍏朵粬瀛楃涓嶅仛瑙i噴琚鍒跺埌緇撴灉涓?/p>
mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
-> 'Saturday October 1997'
mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s');
-> '22:23:00'
mysql> select DATE_FORMAT('1997-10-04 22:23:00',
'%D %y %a %d %m %b %j');
-> '4th 97 Sat 04 10 Oct 277'
mysql> select DATE_FORMAT('1997-10-04 22:23:00',
'%H %k %I %r %T %S %w');
-> '22 22 10 10:23:00 PM 22:23:00 00 6'
MySQL3.23涓紝鍦ㄦ牸寮忎慨楗扮瀛楃鍓嶉渶瑕?銆傚湪MySQL鏇存棭鐨勭増鏈腑錛?鏄彲閫夌殑銆?/p>
TIME_FORMAT(time,format)
榪欒薄涓婇潰鐨凞ATE_FORMAT()鍑芥暟涓鏍蜂嬌鐢紝浣嗘槸format瀛楃涓插彧鑳藉寘鍚鐞嗗皬鏃躲佸垎閽熷拰縐掔殑閭d簺鏍煎紡淇グ絎︺?/p>
鍏朵粬淇グ絎︿駭鐢熶竴涓狽ULL鍊兼垨0銆?nbsp;
CURDATE()
CURRENT_DATE
浠?YYYY-MM-DD'鎴朰YYYMMDD鏍煎紡榪斿洖浠婂ぉ鏃ユ湡鍊鹼紝鍙栧喅浜庡嚱鏁版槸鍦ㄤ竴涓瓧絎︿覆榪樻槸鏁板瓧涓婁笅鏂囪浣跨敤銆?nbsp;
mysql> select CURDATE();
-> '1997-12-15'
mysql> select CURDATE() + 0;
-> 19971215
CURTIME()
CURRENT_TIME
浠?HH:MM:SS'鎴朒HMMSS鏍煎紡榪斿洖褰撳墠鏃墮棿鍊鹼紝鍙栧喅浜庡嚱鏁版槸鍦ㄤ竴涓瓧絎︿覆榪樻槸鍦ㄦ暟瀛楃殑涓婁笅鏂囪浣跨敤銆?nbsp;
mysql> select CURTIME();
-> '23:50:26'
mysql> select CURTIME() + 0;
-> 235026
NOW()
SYSDATE()
CURRENT_TIMESTAMP
浠?YYYY-MM-DD HH:MM:SS'鎴朰YYYMMDDHHMMSS鏍煎紡榪斿洖褰撳墠鐨勬棩鏈熷拰鏃墮棿錛屽彇鍐充簬鍑芥暟鏄湪涓涓瓧絎︿覆榪樻槸鍦ㄦ暟瀛楃殑
涓婁笅鏂囪浣跨敤銆?nbsp;
mysql> select NOW();
-> '1997-12-15 23:50:26'
mysql> select NOW() + 0;
-> 19971215235026
UNIX_TIMESTAMP()
UNIX_TIMESTAMP(date)
濡傛灉娌℃湁鍙傛暟璋冪敤錛岃繑鍥炰竴涓猆nix鏃墮棿鎴寵(浠?1970-01-01 00:00:00'GMT寮濮嬬殑縐掓暟)銆傚鏋淯NIX_TIMESTAMP()鐢ㄤ竴涓猟ate鍙傛暟琚皟鐢紝瀹冭繑鍥炰粠'1970-01-01 00:00:00' GMT寮濮嬬殑縐掓暟鍊箋俤ate鍙互鏄竴涓狣ATE瀛楃涓層佷竴涓狣ATETIME瀛楃涓層佷竴涓猅IMESTAMP鎴栦互YYMMDD鎴朰YYYMMDD鏍煎紡鐨?鏈湴鏃墮棿鐨勪竴涓暟瀛椼?nbsp;
mysql> select UNIX_TIMESTAMP();
-> 882226357
mysql> select UNIX_TIMESTAMP('1997-10-04 22:23:00');
-> 875996580
褰揢NIX_TIMESTAMP琚敤浜庝竴涓猅IMESTAMP鍒楋紝鍑芥暟灝嗙洿鎺ユ帴鍙楀鹼紝娌℃湁闅愬惈鐨?#8220;string-to-unix-timestamp”鍙樻崲 www.knowsky.com銆?/p>
FROM_UNIXTIME(unix_timestamp)
浠?YYYY-MM-DD HH:MM:SS'鎴朰YYYMMDDHHMMSS鏍煎紡榪斿洖unix_timestamp鍙傛暟鎵琛ㄧず鐨勫鹼紝鍙栧喅浜庡嚱鏁版槸鍦ㄤ竴涓瓧絎︿覆榪樻槸鎴栨暟瀛椾笂涓嬫枃涓浣跨敤銆?nbsp;
mysql> select FROM_UNIXTIME(875996580);
-> '1997-10-04 22:23:00'
mysql> select FROM_UNIXTIME(875996580) + 0;
-> 19971004222300
FROM_UNIXTIME(unix_timestamp,format)
榪斿洖琛ㄧず Unix 鏃墮棿鏍囪鐨勪竴涓瓧絎︿覆錛屾牴鎹甪ormat瀛楃涓叉牸寮忓寲銆俧ormat鍙互鍖呭惈涓嶥ATE_FORMAT()鍑芥暟鍒楀嚭鐨勬潯鐩悓鏍風殑淇グ絎︺?nbsp;
mysql> select FROM_UNIXTIME(UNIX_TIMESTAMP(),
'%Y %D %M %h:%i:%s %x');
-> '1997 23rd December 03:43:30 x'
SEC_TO_TIME(seconds)
榪斿洖seconds鍙傛暟錛屽彉鎹㈡垚灝忔椂銆佸垎閽熷拰縐掞紝鍊間互'HH:MM:SS'鎴朒HMMSS鏍煎紡鍖栵紝鍙栧喅浜庡嚱鏁版槸鍦ㄤ竴涓瓧絎︿覆榪樻槸鍦ㄦ暟瀛椾笂涓嬫枃涓浣跨敤銆?nbsp;
mysql> select SEC_TO_TIME(2378);
-> '00:39:38'
mysql> select SEC_TO_TIME(2378) + 0;
-> 3938
TIME_TO_SEC(time)
榪斿洖time鍙傛暟錛岃漿鎹㈡垚縐掋?nbsp;
mysql> select TIME_TO_SEC('22:23:00');
-> 80580
mysql> select TIME_TO_SEC('00:39:38');
-> 2378
var jQuery = (function() {
// 鏋勫緩jQuery瀵硅薄
var jQuery = function( selector, context ) {
return new jQuery.fn.init( selector, context, rootjQuery );
}
// jQuery瀵硅薄鍘熷瀷
jQuery.fn = jQuery.prototype = {
constructor: jQuery,
init: function( selector, context, rootjQuery ) {
// selector鏈変互涓?/span>7縐嶅垎鏀儏鍐碉細
// DOM鍏冪礌
// body錛堜紭鍖栵級
// 瀛楃涓詫細HTML鏍囩銆?/span>HTML瀛楃涓層?/span>#id銆侀夋嫨鍣ㄨ〃杈懼紡
// 鍑芥暟錛堜綔涓?/span>ready鍥炶皟鍑芥暟錛?/span>
// 鏈鍚庤繑鍥炰吉鏁扮粍
}
};
// Give the init function the jQuery prototype for later instantiation
jQuery.fn.init.prototype = jQuery.fn;
// 鍚堝茍鍐呭鍒扮涓涓弬鏁頒腑錛屽悗緇ぇ閮ㄥ垎鍔熻兘閮介氳繃璇ュ嚱鏁版墿灞?/span>
// 閫氳繃jQuery.fn.extend鎵╁睍鐨勫嚱鏁幫紝澶ч儴鍒嗛兘浼氳皟鐢ㄩ氳繃jQuery.extend鎵╁睍鐨勫悓鍚嶅嚱鏁?/span>
jQuery.extend = jQuery.fn.extend = function() {};
// 鍦?/span>jQuery涓婃墿灞曢潤鎬佹柟娉?/span>
jQuery.extend({
// ready bindReady
// isPlainObject isEmptyObject
// parseJSON parseXML
// globalEval
// each makeArray inArray merge grep map
// proxy
// access
// uaMatch
// sub
// browser
});
// 鍒拌繖閲岋紝jQuery瀵硅薄鏋勯犲畬鎴愶紝鍚庤竟鐨勪唬鐮侀兘鏄jQuery鎴?/span>jQuery瀵硅薄鐨勬墿灞?/span>
return jQuery;
})();
window.jQuery = window.$ = jQuery;
})(window);
(function( window, undefined ) { // jquery code })(window); |
1.榪欐槸涓涓?/span>鑷皟鐢ㄥ尶鍚嶅嚱鏁?/span>銆備粈涔堜笢涓滃憿錛熷湪絎竴涓嫭鍙峰唴錛屽垱寤轟竴涓尶鍚嶅嚱鏁幫紱絎簩涓嫭鍙鳳紝绔嬪嵆鎵ц
2.涓轟粈涔堣鍒涘緩榪欐牱涓涓?#8220;鑷皟鐢ㄥ尶鍚嶅嚱鏁?#8221;鍛紵
閫氳繃瀹氫箟涓涓尶鍚嶅嚱鏁幫紝鍒涘緩浜嗕竴涓?#8220;縐佹湁”鐨勫懡鍚嶇┖闂達紝璇ュ懡鍚嶇┖闂寸殑鍙橀噺鍜屾柟娉曪紝涓嶄細鐮村潖鍏ㄥ眬鐨勫懡鍚嶇┖闂淬傝繖鐐歸潪甯告湁鐢ㄤ篃鏄竴涓狫S妗嗘灦蹇呴』鏀寔鐨勫姛鑳斤紝jQuery琚簲鐢ㄥ湪鎴愬崈涓婁竾鐨凧avaScript紼嬪簭涓紝蹇呴』紜繚jQuery鍒涘緩鐨勫彉閲忎笉鑳藉拰瀵煎叆浠栫殑紼嬪簭鎵浣跨敤鐨勫彉閲忓彂鐢熷啿紿併?/span>
3.鍖垮悕鍑芥暟浠庤娉曚笂鍙嚱鏁扮洿鎺ラ噺錛孞avaScript璇硶闇瑕佸寘鍥村尶鍚嶅嚱鏁扮殑鎷彿錛屼簨瀹炰笂鑷皟鐢ㄥ尶鍚嶅嚱鏁版湁涓ょ鍐欐硶錛堟敞鎰忔爣綰簡鐨勫彸鎷彿錛夛細
(function() {
console.info( this );
console.info( arguments );
}( window )
);
(function() {
console.info( this );
console.info( arguments );
}
)( window );
4.涓轟粈涔堣浼犲叆window鍛紵
閫氳繃浼犲叆window鍙橀噺錛屼嬌寰梬indow鐢卞叏灞鍙橀噺鍙樹負灞閮ㄥ彉閲忥紝褰撳湪jQuery浠g爜鍧椾腑璁塊棶window鏃訛紝涓嶉渶瑕佸皢浣滅敤鍩熼摼鍥為鍒伴《灞備綔鐢ㄥ煙錛岃繖鏍峰彲浠ユ洿蹇殑璁塊棶window錛涜繖榪樹笉鏄叧閿墍鍦紝鏇撮噸瑕佺殑鏄紝灝唚indow浣滀負鍙傛暟浼犲叆錛屽彲浠ュ湪鍘嬬緝浠g爜鏃惰繘琛屼紭鍖栵紝鐪嬬湅jquery-1.6.1.min.js錛?/span>
(function(a,b){})(window); // window 琚紭鍖栦負 a |
5.涓轟粈涔堣鍦ㄥ湪鍙傛暟鍒楄〃涓鍔爑ndefined鍛紵
鍦?nbsp;鑷皟鐢ㄥ尶鍚嶅嚱鏁?/span> 鐨勪綔鐢ㄥ煙鍐咃紝紜繚undefined鏄湡鐨勬湭瀹氫箟銆傚洜涓簎ndefined鑳藉琚噸鍐欙紝璧嬩簣鏂扮殑鍊箋?br />
undefined = "now it's defined"; alert( undefined ); |
嫻忚鍣?/strong> | 嫻嬭瘯緇撴灉 | 緇撹 |
ie | now it's defined | 鍙互鏀瑰彉 |
firefox | undefined | 涓嶈兘鏀瑰彉 |
chrome | now it's defined | 鍙互鏀瑰彉 |
opera | now it's defined | 鍙互鏀瑰彉 |
6. 娉ㄦ剰鍒版簮鐮佹渶鍚庣殑鍒嗗彿浜嗗悧錛?/span>
鍒嗗彿鏄彲閫夌殑錛屼絾鐪佺暐鍒嗗彿騫朵笉鏄竴涓ソ鐨?/span>緙栫▼涔犳儻錛涗負浜嗘洿濂界殑鍏煎鎬у拰鍋ュ.鎬э紝璇峰湪姣忚浠g爜鍚庡姞涓婂垎鍙峰茍鍏繪垚涔犳儻銆?/span>
Jquery鐨刟pi涓彁渚涗簡瀵瑰厓绱犲簲鐢╠isabled鍜宺eadonly灞炴х殑鏂規硶錛屽湪榪欓噷璁板綍涓嬨傚涓嬶細
1.readonly
銆銆$('input').attr("readonly","readonly")//灝唅nput鍏冪礌璁劇疆涓簉eadonly
銆銆$('input').removeAttr("readonly");//鍘婚櫎input鍏冪礌鐨剅eadonly灞炴?br />
銆銆 if($('input').attr("readonly")==true)//鍒ゆ柇input鍏冪礌鏄惁宸茬粡璁劇疆浜唕eadonly灞炴?/p>
銆銆 瀵逛簬涓哄厓绱犺緗畆eadonly灞炴у拰鍙栨秷readonly灞炴х殑鏂規硶榪樻湁濡備笅涓ょ錛?br /> 銆銆$('input').attr("readonly",true)//灝唅nput鍏冪礌璁劇疆涓簉eadonly
銆銆$('input').attr("readonly",false)//鍘婚櫎input鍏冪礌鐨剅eadonly灞炴?/p>
銆銆$('input').attr("readonly","readonly")//灝唅nput鍏冪礌璁劇疆涓簉eadonly
銆銆$('input').attr("readonly","")//鍘婚櫎input鍏冪礌鐨剅eadonly灞炴?br /> 2.disabled
銆銆 $('input').attr("disabled","disabled")//灝唅nput鍏冪礌璁劇疆涓篸isabled
銆銆$('input').removeAttr("disabled");//鍘婚櫎input鍏冪礌鐨刣isabled灞炴?br />
銆銆if($('input').attr("disabled")==true)//鍒ゆ柇input鍏冪礌鏄惁宸茬粡璁劇疆浜哾isabled灞炴?/p>
銆銆瀵逛簬涓哄厓绱犺緗甦isabled灞炴у拰鍙栨秷disabled灞炴х殑鏂規硶榪樻湁濡備笅涓ょ錛?br /> 銆銆$('input').attr("disabled",true)//灝唅nput鍏冪礌璁劇疆涓篸isabled
銆銆$('input').attr("disabled",false)//鍘婚櫎input鍏冪礌鐨刣isabled灞炴?/p>
銆銆$('input').attr("disabled","disabled")//灝唅nput鍏冪礌璁劇疆涓篸isabled
銆銆$('input').attr("disabled","")//鍘婚櫎input鍏冪礌鐨刣isabled灞炴?/p>
銆銆璺熷洟娓?/strong>
銆銆鍥㈤槦鏃呰涓紝鏈澶у潡鐨勬尐瀹拌垂涓昏鏄喘鐗╁簵銆佺儳棣?灝忕殑璐圭敤涓昏鏄湅浜哄銆佹綔姘淬佷簰鍔ㄨ妭鐩傛諱箣鏈鍚庝綘鐨勮姳閿寰堝彲鑳借秴鍑哄洟璐廣?/p>
銆銆鏈変簺浜哄湪褰撳湴鎶ュ悕鍙傚姞“涓鏃ユ父”絳夛紝甯歌鐨勮瀹版柟寮忔槸浠庤繖瀹舵梾琛岀ぞ琚?#8220;鍗?#8221;鍒板彟涓瀹舵梾琛岀ぞ錛屽彲鑳借繕瑕佸繊鍙楅潪甯告伓鍔g殑鏈嶅姟鎬佸害銆?/p>
銆銆闃插鏀葷暐錛?/p>
銆銆1.閫夋嫨姝h銆佽妯″ぇ鐨勬梾琛岀ぞ銆?/p>
銆銆2.鍦ㄧ璁㈠悎鍚岀殑鏃跺欙紝緇嗚妭涓瀹氳闂竻妤氾紝鏈変簺涓滆タ闇瑕侀澶栨敞鏄庡湪鍚堝悓涓紝浠ョ‘淇濊嚜韜殑鍒╃泭鑳藉寰楀埌淇濋殰銆?/p>
銆銆3.鍦ㄥ垏韜埄鐩婂彈鍒頒鏡瀹崇殑鏃跺欙紝绔嬪埢鎷ㄦ墦鐩稿叧鎶曡瘔鐢佃瘽錛屽繀瑕佹椂鎶ヨ銆?/p>
銆銆鑷姪娓?/strong>
銆銆銆愬悆嫻烽矞銆?/p>
銆銆瑕佷箞緙烘枻鐭袱錛岃涔堝氨鏄澶╀環鐨勬搗椴滄墍“鎵撹觸”錛屽皯鍒欏嚑鐧撅紝澶氬垯鍑犲崈錛屾櫘閫氭父瀹㈤毦浠ユ壙鍙椼?/p>
銆銆闃插鏀葷暐錛?/p>
銆銆1.濡傛灉鏈夊娓搞佸嚭縐熻濺鍙告満銆佹懇鎵樿濺澶佷笁杞濺澶悜浣犳瀬鍔涙帹鑽愭煇鏌愭搗椴滃簵錛岃澶氱暀涓績鐪鹼紝鎴栬鍒頒簡閭i噷浣犲氨韜笉鐢卞繁浜?#8230;…涓嶈鍚俊璺竟鍙戝箍鍛娿佸彂鍚嶇墖鐨勬父璇淬?/p>
銆銆2.鍚冩搗椴滃彲浠ヨ冭檻嫻烽矞甯傚満銆傚彲浠ヤ拱嫻烽矞鐩存帴鍔犲伐錛屾垚鏈浉瀵逛綆寤夛紝鏂逛究涓斾究瀹溿?/p>
銆銆3.榪滅榛戝績嫻烽矞搴椼?/p>
銆銆榛戝績嫻烽矞搴椾竴鑸垎甯冨湪楂樼閰掑簵鏃佹垨鑰呯甯傚尯杈冭繙鐨勫湴鏂癸紝楠椾漢鐨勬柟娉曟湁鐨勬瀬鍏跺じ寮犮?/p>
銆銆A.褰撲綘鎸囧悜涓涓笢瑗褲侀棶浠鋒牸鐨勬椂鍊欙紝灝忎簩欏哄娍鎷垮嚭灝卞湪浣犵溂鍓嶆媿姝伙紝浣犺繕娌″洖榪囩榪欎釜涓滆タ宸茬粡闇瑕佷綘鏉ヤ拱鍗曚簡!
銆銆B.浣犻棶浠鋒牸鐨勬椂鍊欙紝鑰佹澘鐑儏鍦板憡璇変綘涓嶈吹鍟︽墠4鍏冩瘡鏂ゅ暒錛屼絾絳変綘緇撹處鐨勬椂鍊欏彲鑳芥槸40鍏冩瘡鏂ゆ垨鑰?00鍏冩瘡鏂ゃ?/p>
銆銆C.涓ラ噸緙烘枻鐭袱銆?/p>
銆銆銆愪拱姘存灉銆?/p>
銆銆鍦ㄤ笁浜氫拱緹庡懗鐨勭儹甯︽按鏋滐紝涔熻鏍煎娉ㄦ剰銆?/p>
銆銆1.鑷甫灝忕Г銆?/p>
銆銆緙烘枻鐭袱鏄皬鍟嗚穿浠渶鎯敤鐨勪紟淇╋紝鑰屾垜浠篃搴旇鍚屾牱緇嗗績涓浜涳紝縐頒竴縐版墍璐拱鐨勭墿鍝佸埌搴曞閲?鍏堣皥浠烽挶鍐嶄寒縐?銆?/p>
銆銆2.鍘繪瑙勭殑姘存灉甯傚満錛屽簵閾哄錛屽競鍦虹鐞嗙浉瀵瑰畬鍠勩?/p>
銆銆3.濡傛灉褰撳湴鏈夌啛浜猴紝鍙互璁╀粬甯︿綘鍘諱拱銆?/p>
銆銆銆愭櫙鐐規父鐜┿?/p>
銆銆1.緗戜笂鎻愬墠璁㈤棬紲ㄣ備竴鑸綉緇滆紲ㄨ兘鏇翠紭鎯狅紝寤鴻鎻愬墠璐エ銆?/p>
銆銆2.涓嶅繀姣忎釜鏅偣閮藉幓錛屽幓涓浜涢噸鐐瑰拰鏈変唬琛ㄦх殑鏅偣渚垮彲銆?/p>
銆銆3.鍏呭垎鍒╃敤鍏氦杞︺佹梾娓鎬笓綰垮反澹佹満鍦哄反澹瓑鍏叡璧勬簮銆?/p>
銆銆4.鍖呰濺綰胯礬涓瀹氳鑷繁璁捐錛屽惁鍒欏鏄撹瀹般?/p>
銆銆5.鎱庝拱鐝嶇彔銆佹按鏅剁瓑銆?/p>
銆銆6.涓夎疆杞﹀拰涓よ疆鎽╃殑錛屽緩璁笉瑕佷箻鍧愶紝鍗遍櫓騫朵笖寰堝鏄撹“瀹?#8221;銆?/p>
銆銆7.浣忓皬閰掑簵錛屽緩璁笉瑕佽鏈嶅姟鍛樺府浣犲彨杞︼紝璇翠笉瀹氫細鍙潵璺熶粬浠湁鍒╃泭閾炬潯鐨勭浉鍏寵濺杈嗐?/p>
銆銆8.鏃犳嫑鑳滄湁鎷涖傚湪浜氶緳婀俱佹搗媯犳咕鐨勯厭搴楀敖鎯呬韓鍙楅槼鍏夛紝灝介噺閬垮厤澶栧嚭銆?/p>