还是oracle文字与格式字符串不匹配.select to oracle这个sql怎么不对，报“文字格式与字符串不匹配”
oracle\u505a\u67e5\u8be2select to_date(start_date,'yyyy-mm-dd')+3 from t_way_lubr\u62a5\u9519\u6587\u5b57\u4e0e\u683c\u5f0f\u5b57\u7b26\u4e32\u4e0d\u5339\u914d\u3002\u8fd9\u4e2a\u95ee\u9898\u662f\uff0c
start_date \u7684\u683c\u5f0f\u95ee\u9898\uff0c\u4f60\u7684start_date \u662f yyyy-mm-dd\u7684\u683c\u5f0f\u5417\uff0c\u6240\u6709\u90fd\u662f
\u6bd4\u5982 2012-05-01
2012-5-1
\u90fd\u662f\u6b63\u786e\u7684
\u4f46\u662f\u5982\u679c20120501 \u5219\u80af\u5b9a\u90fd\u662f\u9519\u8bef\u7684
oracle\u91cc\u9762\u7684'yyyy-mm-dd'\u4e0d\u533a\u5206\u5927\u5c0f\u5199\uff08\u53cd\u6b63\u7528\u5c0f\u5199\u5c31\u5bf9\u4e86\uff09
\u4e00\u822c\u51fa\u73b0\u6b64\u7c7b\u95ee\u9898\u662f\u5c06\u65e5\u671f\u578b\u7684\u5b57\u6bb5\u4e2d\u63d2\u5165\u4e86\u5b57\u7b26\u578b\u7684\u6570\u636e\uff0c\u5bfc\u81f4\u6570\u636e\u5e93\u4e0d\u53ef\u8bc6\u522b\u800c\u62a5\u9519\u3002
\u5982\uff1a\u6709\u5982\u4e0btest\u8868
123
create table test(id int,begin_date date);
\u73b0\u5728\u6267\u884c\u63d2\u5165\u8bed\u53e5\uff1a
1
insert into test values (1,'2015-01-01');
\u5219\u4f1a\u62a5\u9519\uff1a
\u5982\u679c\u6b63\u786e\u63d2\u5165\uff0c\u5219\u8981\u5c06\u5b57\u7b26\u578b\u6570\u636e\u8f6c\u6210\u65e5\u671f\u578b\u6570\u636e\uff1a
1
insert into test values (1,to_date('2015-01-01','yyyy-mm-dd'));
你电脑上的日期格式是什麽样的？
控制面板里---地区与语言里-格式更改下
select * from COLUMN__CONTENTS where To_char(To_date(sysdate, 'yyyy-mm-dd ') - To_date( TOP_START_DATE, 'yyyy-mm-dd '))>7 你觉得这样写有问题么。
起码
select * from COLUMN__CONTENTS where To_char(sysdate, 'yyyy-mm-dd ') - To_char( to_date(TOP_START_DATE, 'yyyy-mm-dd '))>7
绛旓細瀛楁涓烘椂闂达紵to_date('2011-04-01 00:11;11','yyyy-mm-dd hh24:mi:ss')鏃堕棿鍋氭潯浠舵渶濂戒笉瑕佺敤绛変簬 鐢ㄨ寖鍥撮潬璋 鎴栬呯敤鏃ユ湡
绛旓細绗竴涓棩鏈燂紝鎬庝箞鑳界敤to_char鍛紵INSERT INTO zo_product VALUES(SEQ_ZO_PRODUCT.NEXTVAL,'鍥句功','姘戝浗钘忎功',999,998, trunc(sysdate), to_date( '2013-1-1 00:00:00 ', 'YYYY-MM-DD HH24:MI:SS '),1);
绛旓細SELECT t_status_st FROM t_status WHERE t_user_id=21 and t_status_date between (TO_DATE('2015-08-01', 'yyyy-mm-dd'))and add_months(to_date('2015-08-1','yyyy-mm-dd'),1) ;add_months 杩斿洖宸茬粡鏄痙ate鏃ユ湡浜嗭紝涓嶉渶瑕佸啀to_date 浜 ...
绛旓細ORACLE 鏀寔鍥藉璇█鐨勪綋绯荤粨鏋勫厑璁镐綘浣跨敤鏈湴鍖栬瑷鏉ュ瓨鍌紝澶勭悊锛屾绱㈡暟鎹傚畠浣挎暟鎹簱宸ュ叿锛岄敊璇秷鎭紝鎺掑簭娆″簭锛屾棩鏈燂紝鏃堕棿锛岃揣甯侊紝鏁板瓧锛屽拰鏃ュ巻鑷姩閫傚簲鏈湴鍖栬瑷鍜屽钩鍙般 褰卞搷oracle鏁版嵁搴撳瓧绗闆嗘渶閲嶈鐨勫弬鏁鏄NLS_LANG鍙傛暟銆傚畠鐨鏍煎紡濡備笅: NLS_LANG = language_territory.charset 瀹冩湁涓変釜缁勬垚閮ㄥ垎...
绛旓細鏈鍚庝竴涓弬鏁拌瘯璇曡繖鏍峰啓 to_date(Graduatetime_in,'yyyy-MM-dd HH24:mi:ss')
绛旓細Oracle瀛楃闆鏄涓涓瓧鑺傛暟鎹殑瑙ｉ噴鐨勭鍙烽泦鍚 鏈夊ぇ灏忎箣鍒 鏈夌浉浜掔殑鍖呭鍏崇郴 ORACLE 鏀寔鍥藉璇█鐨勪綋绯荤粨鏋勫厑璁镐綘浣跨敤鏈湴鍖栬瑷鏉ュ瓨鍌 澶勭悊 妫绱㈡暟鎹 瀹冧娇鏁版嵁搴撳伐鍏 閿欒娑堟伅 鎺掑簭娆″簭 鏃ユ湡 鏃堕棿 璐у竵 鏁板瓧 鍜屾棩鍘嗚嚜鍔ㄩ傚簲鏈湴鍖栬瑷鍜屽钩鍙 褰卞搷oracle鏁版嵁搴撳瓧绗闆嗘渶閲嶈鐨勫弬鏁版槸NLS_LANG鍙傛暟 瀹冪殑鏍煎紡...
绛旓細寰堜箙娌＄敤ORACEL锛孧DAT鏄椂闂村瀷鐨勫惂锛熸垨鑰呭煎簲璇ヨ繖鏍峰啓:'2011-8-3 23:32:59.000000'?璇曚竴涓
绛旓細濡傛灉鎸囧畾鐨勬樉绀鏍煎紡鍖呭惈涓枃瀛楃锛岄偅涔堣浆鎹㈠悗鐨勫瓧绗︿腑灏变細鏈変腑鏂囥傞渶瑕佹敞鎰忕殑鏄锛屽湪鏁版嵁搴撲腑瀛樺偍鐨勬棩鏈熺被鍨嬪苟涓嶆槸浠ュ瓧绗﹀舰寮忓瓨鍌ㄧ殑锛屽畠鏄互涓绉嶇壒娈婄殑浜岃繘鍒舵牸寮忓瓨鍌ㄧ殑銆傚湪杩涜鏃ユ湡涓庡瓧绗涔嬮棿鐨勮浆鎹㈡椂锛屼細鏍规嵁鎸囧畾鐨勬牸寮忓皢鏃ユ湡鍊艰浆鎹负瀛楃褰㈠紡銆傚鏋滄病鏈夋寚瀹氭樉绀烘牸寮忥紝绯荤粺浼氫娇鐢ㄩ粯璁ょ殑杞崲鏍煎紡銆傚鏋滀綘閬囧埌...
绛旓細瑙ｅ喅杩欑被闂锛屼篃鍙互鍏堝皢鏁版嵁鍔犺浇鍒板叿鏈夌浉鍚屽瓧绗﹂泦鐨勬湇鍔″櫒涓婏紝鐒跺悗鐢ㄨ浆鎹㈠伐鍏峰嵏鍑轰负foxbase 鏍煎紡鎴朼ccess鏍煎紡鏁版嵁搴擄紝鍐嶇敤杞崲宸ュ叿杞叆鍒颁笉鍚屽瓧绗﹂泦鐨Oracle鏁版嵁搴涓紝杩欐牱灏遍伩鍏嶄簡Oracle瀛楃闆嗙殑鍥版壈銆傜洰鍓嶆暟鎹簱鏍煎紡杞崲鐨勫伐鍏峰緢澶,鍍弍ower builder5.0浠ヤ笂鐗堟湰鎻愪緵鐨刾ipeline鍙奙icrosoft Access鏁版嵁搴撴彁渚涚殑...
绛旓細ORACLE鏁版嵁搴撳瓧绗闆,鍗Oracle鍏ㄧ悆鍖栨敮鎸(Globalization Support),鎴栧嵆鍥藉璇█鏀寔(NLS)鍏朵綔鐢鏄鐢ㄦ湰鍥借瑷鍜屾牸寮鏉ュ瓨鍌ㄣ佸鐞嗗拰妫绱㈡暟鎹傚埄鐢ㄥ叏鐞冨寲鏀寔,ORACLE涓虹敤鎴锋彁渚涜嚜宸辩啛鎮夌殑鏁版嵁搴撴瘝璇幆澧,璇稿鏃ユ湡鏍煎紡銆佹暟瀛楁牸寮忓拰瀛樺偍搴忓垪绛夈侽racle鍙互鏀寔澶氱璇█鍙婂瓧绗﹂泦,鍏朵腑oracle8i鏀寔48绉嶈瑷銆76涓浗瀹跺湴鍩熴229绉嶅瓧...
