db2字符串转换日期问题 求助：sql2012中从字符串转换日期和/或时间时，转换失败...
db2 \u5b57\u7b26\u4e32\u7c7b\u578b\u8f6c\u6362\u6210\u65e5\u671f\u7c7b\u578b1\uff09\u5b57\u7b26\u8f6c\u65e5\u671f\uff1a select to_date(\u5b57\u6bb5\u540d,'yyyy-mm-dd hh24:mi:ss') from \u8868\u540d
2\uff09\u65e5\u671f\u8f6c\u5b57\u7b26\uff1a db2 "select to_char(\u5b57\u6bb5\u540d, 'yyyy-mm-dd hh24:mi:ss') from \u8868\u540d
\u68c0\u67e5\u4e0b\u4e24\u4e2a\u673a\u5668\u7684\u65f6\u95f4\uff0c\u65e5\u671f\u683c\u5f0f\u8bbe\u7f6e\u662f\u5426\u4e00\u6837\uff0c\u6b63\u5e38\u53ef\u80fd\u662f\u898124\u5c0f\u65f6\u5236\u4e0d\u5e26\u4e2d\u6587\u7684\u90a3\u79cd\uff0c\u6709\u4e2d\u6587\u7684\u683c\u5f0f\u4e0d\u5bf9\u53ef\u80fd\u5c31\u9020\u6210\u6587\u672c \u65e0\u6cd5\u8f6c\u6362\u4e3a\u65e5\u671f\u6570\u636e
因为传yyyy-MM-dd HH:mm:ss格式的话DB2会隐性转成timestamp，传yyyy-MM-dd HH:mm个话隐性转就会报错
绛旓細鍙兘鑷繁缂栧啓鍑芥暟澶勭悊锛DB2娌℃湁鐜版垚鐨勬柟娉曟潵澶勭悊杩欎釜 鍙互鍙傝冭繖涓 SELECT CASE when MONTH(DATE('2012-01-01')) IN (1,2,3) THEN 1 when MONTH(DATE('2012-01-01')) IN (4,5,6) THEN 2 when MONTH(DATE('2012-01-01')) IN (7,8,0) THEN 3 when MONTH(DATE('2012-01-01'))...
绛旓細鏄绠楃殑寮濮鏃ユ湡銆俿tartdate 鏄繑鍥 datetime 鎴 smalldatetime 鍊兼垨鏃ユ湡鏍煎紡瀛楃涓鐨勮〃杈惧紡銆傚洜涓 smalldatetime 鍙簿纭埌鍒嗛挓锛屾墍浠ュ綋鐢 smalldatetime 鍊兼椂锛岀鍜屾绉掓绘槸 0銆傚鏋滄偍鍙寚瀹氬勾浠界殑鏈鍚庝袱浣嶆暟瀛楋紝鍒欏皬浜庢垨绛変簬 "涓や綅鏁板勾浠芥埅姝㈡湡 "閰嶇疆閫夐」鐨勫肩殑鏈鍚庝袱浣嶆暟瀛...
绛旓細8-14涓惂锛宒dmmyyyy鎴栬卻smmhhddmmyyyy
绛旓細姣忎釜鏈堢殑绗竴澶 values TO_CHAR((SUBSTR(current date,1,8)||'01'),'YYYYMMDD')鍙戠エ鏃ユ湡date values TO_char(鍙戠エ鏃ユ湡,'YYYYMMDD')璇曡瘯杩欎釜鍚с倂alues Integer(TO_CHAR((SUBSTR(current date,1,8)||'01'),'YYYYMMDD') - TO_char(鍙戠エ鏃ユ湡,'YYYYMMDD'))/30 ...
绛旓細鍒嗙被姹囨讳娇鐢⊿QL鐨凣ROUP BY锛岃繖浜涜鍙ュ悓鏍烽傜敤浜DB2鐨鏃ユ湡瀛楁銆傚鏃ユ湡姹囨诲彲鑳戒細澶粏鍖栦簡涓鐐癸紝鍙互鎻愬彇鐨勫勾銆佹湀涔嬪悗鍐嶈繘琛屾眹鎬汇 鎻愬彇骞存湀浣跨敤鍑芥暟YEAR锛孧ONTH銆
绛旓細Char()鏄畾闀垮瓧绗︿覆锛1-255锛夛紝varchar()涓洪潪瀹氶暱瀛楃涓诧紙1-32672锛鏃ユ湡,鏃堕棿褰㈡佸彉涓哄瓧绗﹀舰鎬: char(current date)锛宑har(current time)灏瀛楃涓茶浆鎹鎴愭棩鏈熸垨鏃堕棿褰㈡:TIMESTAMP('2002-10-2012:00:00'),DATE('2002-10-20'),DATE('10/20/2002'),TIME('12:00:00')鐩墠DB2 V8涔熸敮鎸乼o_...
绛旓細DB2閲岄潰娌℃湁鑷甫鐨刉EEK(DATE)鏂规硶锛屽彧鑳芥妸鏃堕棿涓茶仈浣岲ATE绫诲瀷瀛楃涓锛岀劧鍚庤皟鐢╓EEK(dateSTring)鏂规硶銆俿elect week('2011-07-25') from sysibm/sysdummy1 闇瑕佺煡閬撲綘EXPEROTdATE鐨勬牸寮忋傘傘
绛旓細1.棣栧厛锛屾妸璇诲彇鍑烘潵鐨勫杞崲鎴怐ateTime绫诲瀷锛屽洜涓瀛楃涓涓嶈兘姣旇緝澶у皬 DateTime dTimeDB1 = Convert.todateTime(鏁版嵁搴撲腑鐨勫);DateTime dTimeDB2 = Convert.todateTime(鏁版嵁搴撲腑鐨勫);2.鐒跺悗锛屽啀杩涜姣旇緝 浣跨敤姣旇緝鏂规硶锛歩f(DateTime.Compare(dTimeDB1 ,dTimeDB2) > 0)璇存槑锛歞TimeDB1 > dTimeDB2鍗...
绛旓細1.鐢ㄥ崟寮曞彿鎷捣鏉ョ殑閮芥槸瀛楃鍨.2.鏃ユ湡鍨嬪彲浠ョ悊瑙ｄ负鐗规畩鐨勫瓧绗﹀瀷,鐗规畩鐨勫湴鏂瑰氨鏄畠鍙互琚暟鎹簱寮曟搸闅愬紡鐨杞崲鎴愬彲璇嗗埆鐨勬棩鏈熷瀷.涔熷氨鏄,鍙湁绗﹀悎涓瀹氭牸寮忕殑瀛楃涓鎵嶅彲浠ヨ杞崲涓烘棩鏈熷瀷.鑷充簬鍒板簳鍝簺鏍煎紡鍙鏁版嵁搴撳紩鎿庤浆鎹㈡垚鏃ユ湡鍨,鍦ㄨ仈鏈哄府鍔╅噷鏈夎缁嗙殑璇存槑....
绛旓細\\闅愯棌鍛戒护鐨勫洖鏄俱 ~ \\鍦╢or涓〃绀轰娇鐢ㄥ寮虹殑鍙橀噺鎵╁睍锛 鍦╯et涓〃绀轰娇鐢ㄦ墿灞曠幆澧冨彉閲忔寚瀹氫綅缃殑瀛楃涓锛 鍦╯et/a涓〃绀烘寜浣嶅彇鍙嶃 % \\浣跨敤涓や釜%鍖呭惈涓涓瓧绗︿覆琛ㄧず寮曠敤鐜鍙橀噺銆傛瘮濡備竴涓%time%鍙互鎵╁睍鍒板綋鍓嶇殑绯荤粺鏃堕棿; 鍗曚釜%绱ц窡0-9鐨...
