DB2如何获得周起始日期,结束日期 sql 如何获取当前时间，所属周的开始时间和结束时间，周一为...
db2\u4e2d\u5982\u4f55\u83b7\u53d6\u5f53\u524d\u65e5\u671f\u524d\u4e00\u5468\u7684\u65e5\u671fSELECT
CURRENT_DATE - (DAYOFWEEK(CURRENT_DATE) - 2 + (ROW_NUMBER() OVER (ORDER BY 1) ) ) DAY AS result
FROM
SYSIBM.SYSCOLUMNS
fetch first 7 rows only;
\u8f93\u51fa\u7ed3\u679c\uff1a
2013-03-24
2013-03-23
2013-03-22
2013-03-21
2013-03-20
2013-03-19
2013-03-18
\u4f60\u53ef\u4ee5\u770b\u60c5\u51b5\uff0c \u81ea\u5df1\u518d\u505a\u4e00\u4e0b\u6392\u5e8f\u3002
SELECT GETDATE() \u5f53\u524d\u65f6\u95f4,DATEADD(DAY,-CASE DATENAME(WEEKDAY,GETDATE()) WHEN '\u661f\u671f\u4e00' THEN 0
WHEN '\u661f\u671f\u4e8c' THEN 1 WHEN '\u661f\u671f\u4e09' THEN 2 WHEN '\u661f\u671f\u56db' THEN 3 WHEN '\u661f\u671f\u4e94' THEN 4 WHEN '\u661f\u671f\u516d' THEN 5 ELSE 6 END,GETDATE()) \u661f\u671f\u4e00\u65e5\u671f,
DATEADD(DAY,CASE DATENAME(WEEKDAY,GETDATE()) WHEN '\u661f\u671f\u4e00' THEN 6
WHEN '\u661f\u671f\u4e8c' THEN 5 WHEN '\u661f\u671f\u4e09' THEN 4 WHEN '\u661f\u671f\u56db' THEN 3 WHEN '\u661f\u671f\u4e94' THEN 2 WHEN '\u661f\u671f\u516d' THEN 1 ELSE 0 END,GETDATE()) \u661f\u671f\u65e5\u65e5\u671f
db2 => select date(days(current date) - dayofweek(current date)+2) as Monday, date(days(current date) - dayofweek(current date) + 8) as Sunday from sysibm.sysdummy1;
MONDAY SUNDAY
---------- ----------
11/28/2011 12/04/2011
1 record(s) selected.
db2 =>
绛旓細涓嬮潰璇彞鍙互寰楀埌褰撳墠鐨鍛ㄧ殑寮濮鍜缁撴潫.db2 => select date(days(current date) - dayofweek(current date)+2) as Monday, date(days(current date) - dayofweek(current date) + 8) as Sunday from sysibm.sysdummy1;MONDAY SUNDAY --- --- 11/28/2011 12/04/2011 1 record(s) selecte...
绛旓細绗竴绉嶆柟娉曪細SELECT DATE,DATENAME(DATE) FROM T 鍗充娇鐢―B2 DATENAME鏃ユ湡鍑芥暟鑾峰緱鏄熸湡鍚锛屽Monday锛孴uesday绛夌瓑锛涚浜岀鏂规硶锛歋ELECT DATE,DAYOFWEEK(DATE) FROM T 鍗充娇鐢―B2 DAYOFWEEK鏃ユ湡鍑芥暟鑾峰緱鏄熸湡鍙凤紝濡傛槦鏈熷ぉ杩斿洖1锛屾槦鏈熶竴杩斿洖2锛屼互姝ょ被鎺ㄣ
绛旓細渚嬪2017骞06鏈堬紝select distinct day (cast(cast(to_date(201706,'yyyymm')+1 months as char(8))||'01' as date) - 1 day) from sysibm.SYSDUMMY1銆侱B2灏辨槸IBM寮鍙戠殑涓绉嶅ぇ鍨嬪叧绯诲瀷鏁版嵁搴撳钩鍙.瀹冩敮鎸佸鐢ㄦ埛鎴栧簲鐢ㄧ▼搴忓湪鍚屼竴鏉QL 璇彞涓煡璇笉鍚宒atabase鐢氳嚦涓嶅悓DBMS涓殑鏁版嵁銆傜洰鍓锛孌B...
绛旓細SELECT CURRENT_DATE - (DAYOFWEEK(CURRENT_DATE) - 2 + (ROW_NUMBER() OVER (ORDER BY 1) ) ) DAY AS result FROM SYSIBM.SYSCOLUMNS fetch first 7 rows only;杈撳嚭缁撴灉锛2013-03-24 2013-03-23 2013-03-22 2013-03-21 2013-03-20 2013-03-19 2013-03-18 浣犲彲浠ョ湅鎯呭喌锛 鑷繁鍐嶅仛...
绛旓細DB2閲岄潰鐨凷QL鏌ヨ璇彞鎸夊懆鍒嗙粍鏄庝箞鍐欑殑 DB2閲岄潰娌℃湁鑷甫鐨刉EEK(DATE)鏂规硶锛鍙兘鎶婃椂闂翠覆鑱斾綅DATE绫诲瀷瀛楃涓诧紝鐒跺悗璋冪敤WEEK(dateSTring)鏂规硶銆俿elect week('2011-07-25') from sysibm/sysdummy1 闇瑕佺煡閬撲綘EXPEROTdATE鐨勬牸寮忋傘傘
绛旓細select DATENAME(week,getdate())杩欐槸鍙栧綋鍓鏃ユ湡鐨勭鍑犲懆 濡傛灉瑕佹寚瀹氬瓧娈电殑鍙鎶奼etdate()鎹负瀛楁鍚嶇О 濡:select DATENAME(week,瀛楁鍚嶇О) as weekNum from 琛ㄥ悕绉 鍙傜収涓嬮潰鐨勫叧浜嶥ATENAME http://www.cnblogs.com/zengwei/archive/2008/06/05/1214295.html ...
绛旓細鐢辩煭鍛ㄦ湡鍏冪礌A銆丅銆丆銆丏鍦ㄥ懆鏈熻〃涓殑浣嶇疆鍙煡锛孉銆丅澶勪簬绗簩鍛ㄦ湡锛孋銆丏澶勪簬绗笁鍛ㄦ湡锛孊銆丏鍚岀涓绘棌锛孊銆丏鏈澶栧眰鐢靛瓙鏁颁箣鍜屼负12锛屾晠鏈澶栧眰鐢靛瓙鏁颁负6锛屾晠B涓篛鍏冪礌锛孌涓篠鍏冪礌锛屼簩鑰呭彲浠ュ舰鎴怱O2銆丼O3涓ょ鍒嗗瓙锛屼笖SO2鍏锋湁婕傜櫧鎬э紝鐢变綅缃叧绯诲彲鐭ワ紝A涓篘鍏冪礌锛孋涓篠i鍏冪礌锛岋紙1锛堿涓篘鍏冪礌锛屽叾...
绛旓細鍗囩骇鍓嶅噯澶 鍗囩骇涔嬪墠锛屽鎴烽渶瑕佽冭檻鍗囩骇鏉′欢鏄惁鍏峰锛岀劧鍚庡埗瀹氬崌绾ц鍒掋傛鏌ュ崌绾ф潯浠 涓昏浠庝袱鏂归潰鏉ユ鏌ユ槸鍚︽敮鎸 DB2 鍗囩骇鍒 V10.5 鐗堟湰銆傚湪 DB2 鐗堟湰鏂归潰锛屽彧鏀寔鐩存帴浠 DB 9.7 涔嬪悗锛堝惈锛夌殑鐗堟湰鍗囩骇锛屽鏋滄槸鏇翠綆鐨勭増鏈 DB2 9.5锛岄渶瑕佸厛鍗囩骇鍒 9.7 鎴 10.1锛岀劧鍚庡啀鍗囩骇鍒 V10.5銆傚缓璁...
绛旓細灏变細灞忚斀鎺夐儴鍒嗙嚎绋嬨係P2杩欐牱鍋氾紝铏界劧鍙互闃茶寖闇囪崱娉㈢被鍨嬬殑锠曡櫕鐥呮瘨锛屽姞寮虹郴缁熷畨鍏紝浣嗘槸涔熷甫浜嗕竴浜涜礋闈㈠奖鍝嶏紝渚嬪褰撲綘浣跨敤BT銆丳2P鎴朏lashGet杞欢涓嬭浇鏃讹紝閮ㄥ垎绾跨▼灏嗚灞忚斀鎺夛紝鍥犳涓嬭浇閫熷害浼氬彉寰楀緢鎱備负姝わ紝浣犲彲浠ラ噰鍙栦互涓嬪绛栵紝鏉ョ獊鐮碩CP骞跺彂杩炴帴鏁帮紝浠庤屾彁楂楽P2鐨勫绾跨▼璁块棶閫熷害銆
绛旓細瀹夎 DB2 V9.7 鑷粠 DB2 V9 寮濮嬶紝DB2 鏀寔鍦ㄦ搷浣滅郴缁熶笂瀹夎澶氫釜鍓湰銆傚崌绾ф暟鎹簱鏈変袱绉嶅畨瑁 DB2 鐨勯夋嫨锛屼竴绉嶆槸鐩存帴鍗囩骇鑰佺増鏈暟鎹簱鍓湰鍒版柊鐨勭増鏈紝鍙﹀涓绉嶆槸瀹夎鏂扮殑鏁版嵁搴撳壇鏈埌鏂扮殑浣嶇疆銆傝繖涓叿浣撹鐪嬬敤鎴风殑鐜瑙勫垝銆備綔鑰呮帹鑽愬畨瑁呮柊鐨勫壇鏈埌鏂扮殑浣嶇疆锛岃繖鏍峰彲浠ヤ笉褰卞搷鑰佺殑鍓湰锛屽鏋滃崌绾ц繃绋嬩腑...
