db2中如何获取当前日期前一周的日期 js怎样获取当前日期前10天的日期?或者是前n天的?
\u600e\u6837\u5728Excel\u4e2d\u83b7\u53d6\u5f53\u524d\u65e5\u671f\u5728excel\u8bbe\u8ba1\u4e2d\u6709\u65f6\u9700\u8981\u83b7\u53d6\u5f53\u524d\u65e5\u671f\uff0c\u5177\u4f53\u64cd\u4f5c\u5982\u4e0b\uff08\u4ee5excel2003\u4e3a\u4f8b\uff09\uff1a
1\u3001\u70b9\u51fb\u9700\u8981\u83b7\u53d6\u5f53\u524d\u65e5\u671f\u7684\u5355\u5143\u683c\uff0c\u5728\u63d2\u5165\u51fd\u6570\u680f\u4e2d\u8f93\u5165\u4ee5\u4e0b\u4ee3\u7801\u3010=today()\u3011\uff0c\u5982\u56fe\u6240\u793a\uff1a
2\u3001\u8fd9\u6837\u5c31\u663e\u793a\u5f53\u524d\u65e5\u671f\u4e86\uff0c\u5982\u56fe\u6240\u793a\uff1a
date=new Date(year,month,day);\u8f6c\u6362\u6807\u51c6\u65e5\u671f\u7c7b\u578b
t=date.getTime();
x=t+(24*60*60*1000*365*n)//n\u4e3a\u7b2c2\u4e2a\u6846\u8f93\u5165\u7684\u5e74\u6570,\uff08\u5929\uff1ax=t+(24*60*60*1000*n);
\uff09
d=new Date();
d.setTime(x);
d\u5c31\u662f\u503c\uff0c\u6539\u53d8\u6210\u4f60\u8981\u7684\u683c\u5f0f\u5c31OK\u4e86
date=new Date(year,month,day);\u8f6c\u6362\u6807\u51c6\u65e5\u671f\u7c7b\u578b t=date.getTime(); x=t+(24*60*60*1000*365*n)//n\u4e3a\u7b2c2\u4e2a\u6846\u8f93\u5165\u7684\u5e74\u6570,\uff08\u5929\uff1ax=t+(24*60*60*1000*n); \uff09 d=new Date(); d.setTime(x); d\u5c31\u662f\u503c\uff0c\u6539\u53d8\u6210\u4f60\u8981\u7684\u683c\u5f0f\u5c31OK\u4e86
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
你可以看情况， 自己再做一下排序。
绛旓細鐢ㄦ埛 timestampdiff鍑芥暟
绛旓細select current date -1 day from sysibm.sysdummy1 杩欑鏃ユ湡绫诲瀷鏄細2014-01-18 values to_date('20140101','yyyy-mm-dd')2014-01-01 00:00:00.0 鏄痶imestamp鏍煎紡锛屾墍浠ユ牸寮忎笉涓鏍 浣犲彲浠ヤ慨鏀逛竴涓嬩綘鐨璇彞锛歴elect * from a where to_char(date1,'yyyy-mm-dd') <>(current date -1 ...
绛旓細浣犺繖涓彲鑳芥槸 CASE WHEN 鐨闂 绗竴绉嶆儏鍐典笅锛 缁撴灉鏄 瀛楃绫诲瀷鐨 鈥樺凡鍒版湡鈥欑浜岀鎯呭喌涓嬶紝 缁撴灉鏄 鏁板瓧绫诲瀷鐨 涔熷氨鏄綘涓涓煡璇紝 鍏朵腑鏌愪竴鍒楃殑鏁版嵁绫诲瀷锛 鍙堟槸瀛楃锛 鍙堟槸鏁板瓧鐨勩傚鑷存煡璇㈠嚭鐜伴敊璇簡銆備綘灏濊瘯鍦ㄥ悗闈㈤偅閲 鍔犱竴涓 TO_CHAR() 鐪嬬湅 TO_CHAR(day (TIMESTAMP (s....
绛旓細寰堢畝鍗曪紝鎶婅繖涓鏃ユ湡+1 鐒跺悗鍙栨湀鍊肩湅鏄惁鐩哥瓑
绛旓細select day(current date), week(current date), month(current date), year(current date) from sysibm.dummy1 current date 涓褰撳墠鏃ユ湡锛宒ay, week, month, year涓哄嚱鏁般
绛旓細鍙互閲囩敤TO_DATE鍑芥暟灏'2012-05'杞寲涓鏃ユ湡鏍煎紡 TO_DATE('2012-05', 'YYYY-MM')渚嬪瓙锛db2 => create table TEST2(c1 timestamp)DB20000I The SQL command completed successfully.db2 => insert into test2 values(to_Date('2012-05', 'YYYY-MM'))DB20000I The SQL command completed ...
绛旓細sql鎸鏃ユ湡涓殑鏈堜唤鏌ヨ濡備笅锛歋QL Server select * from [data] where DATEPART(m,[date])=2 Access select * from [data] where DATEPART('m',[date])=2 璇存槑锛欴ATEPART(datepart,date)杩斿洖琛ㄧず鎸囧畾鏃ユ湡鐨鎸囧畾閮ㄥ垎鐨勬暣鏁 datepart 瑕鍙栧緱鐨勬棩鏈閮ㄥ垎 锛 m 琛ㄧず鏈堜唤锛宒琛ㄧず鏃ワ紝yyyy琛ㄧず骞 date ...
绛旓細鍙瓫閫夊嚭2鏈堜唤鐨勬棩鏈骞舵彁鍙鏃ユ湡涓殑骞翠唤锛岀劧鍚庢嫾鎺3鏈1鍙凤紝鍐嶅噺1澶╋紝寰楀埌褰撳勾2鏈堝簳鐨勬棩鏈燂紝鏈鍚庢彁鍙栬鏈堢殑澶╂暟鏉ヨ繘琛屽垽鏂傛垜娌＄敤杩DB2锛屼笅闈㈢敤MySQL绀鸿寖鐢ㄨ繖涓濊矾杩涜鍒ゆ柇鐨勫疄楠岋細-- 閫夊嚭2鏈堜唤鏃ユ湡锛屽苟鍒楀嚭鏈堝簳鏈鍚庝竴鏃 select *,date_add(concat(year(d1),'-03-01'),interval -1 day)as ...
绛旓細杩欎釜鏍规嵁鏁版嵁閲忔潵鐨锛氳嫢鏁版嵁涓嶅ぇ锛氱敤crontab 鍐欎釜鑴氭湰璇█锛屽厛鑾峰彇褰撳墠鏃堕棿 姣斿php 涓$day=inter(date("d",time()));//鑾峰彇褰撳墠鏃ユ湡 if($day=1){//鍒ゆ柇鏄惁鏄湀鍒 do{//鏁版嵁澶у垎椤靛垹闄わ紱鏍规嵁鏃堕棿鍙 return = delData锛坱ime<strtotime(鈥-3 month鈥)锛夛紱}while($total >(page-1)*姣忛〉...
绛旓細鍒嗙被姹囨讳娇鐢⊿QL鐨凣ROUP BY锛岃繖浜涜鍙ュ悓鏍烽傜敤浜DB2鐨勬棩鏈瀛楁銆傚鏃ユ湡姹囨诲彲鑳戒細澶粏鍖栦簡涓鐐癸紝鍙互鎻愬彇鐨勫勾銆佹湀涔嬪悗鍐嶈繘琛屾眹鎬汇 鎻愬彇骞存湀浣跨敤鍑芥暟YEAR锛孧ONTH銆
