发表于 2009-1-5 19:48
| 
Oracle涓竴涓棩鏈熸煡鎵剧殑璇尯
鍙戝竷: 2008-6-30 14:56 | 浣滆: admin | 鏌ョ湅: 9娆
Oracle涓竴涓棩鏈熸煡鎵剧殑璇尯
鐑 鑽
銆愬瓧浣擄細灏 澶с
Oracle涓竴涓棩鏈熸煡鎵剧殑璇尯
浣滆咃細浣氬悕 鏂囩珷鏉ユ簮锛氫笉璇 鐐瑰嚮鏁帮細822 鏇存柊鏃堕棿锛2006-4-17 
缁忓父瑕佸湪鏁版嵁涓绱㈣繎涓涓湀鏉ュ彂鐢熺殑鏁版嵁锛屾墍浠ラ噰鐢ㄥ涓嬭鍙elect * from eventtable where eventdate>sysdate-30,褰撴暟鎹噺灏忕殑鏃跺欒繕鐪嬩笉鍑烘潵锛屾暟鎹噺澶т竴浜涘氨浼氬彂鐜颁笂闈㈢殑璇彞寰堟參锛屼絾eventdate锛堟棩鏈熷瀷瀛楁锛変笂涔熸槸鏈夌储寮曠殑锛屽彲涓轰粈涔堜細鎱㈠憿锛 鍘熸潵鏄痮racle鍦ㄨ繘琛屾煡鎵剧殑鏃跺欎笉鏂湴鍘诲彇sysdate杩欎釜涓嶆柇鍙樺寲鐨勫硷紝鑰屼笉鏄垜浠兂璞′腑鐨勪竴娆′骇鐢熶竴涓潯浠惰鍙ョ劧鍚庤繘琛屾煡鎵俱備负浜嗗姞蹇熷害锛屾垜浠彲浠ュ厛鎶婂綋澶╃殑鏃ユ湡鍙栧嚭鏉ワ紝鐒跺悗杞垚瀛楃涓插悗鍐嶇敤濡備笅璇彞鏌ワ紝select * from eventtable where eventdate > to_date(2001-12-1,yyyy-mm-dd)銆傞熷害绔熺劧宸簡鍑犲崄鍊嶃
銉
