]]>
\b 絀烘牸(\u0008)
\r 鎹㈣(\u000d)
\f 鎹㈤〉(\u000c)
\' 鍗曞紩鍙?\u0027)
\" 鍙屽紩鍙?\u0022)
\\ 鍙嶆枩鏉?\u005c)
\ddd 涓変綅鍏繘鍒?
\udddd 鍥涗綅鍗佸叚榪涘埗
]]>
榪欐槸涓闂ㄥ祵鍏ュ紡紜歡鍩虹璇劇▼錛屽祵鍏ュ紡鏄蔣紜歡緇撳悎鐨勬妧鏈紝鎼炲祵鍏ュ紡杞歡鐨勪漢搴斿ARM澶勭悊鍣ㄥ伐浣滃師鐞嗗拰鎺ュ彛鎶鏈湁鍏呭垎浜嗚В錛屽寘鎷珹RM鐨勬眹緙栨寚浠ょ郴緇熴?nbsp; 闃呰鍏ㄦ枃
]]>
鍦?Host>鍜?/host>涔嬮棿鍔犱笂
闃呰鍏ㄦ枃
]]>
jar 鏄殢 JDK 瀹夎鐨勶紝鍦? JDK 瀹夎鐩綍涓嬬殑 bin 鐩綍涓紝W(xué)indows 涓嬫枃浠跺悕涓? jar.exe錛孡inux 涓嬫枃浠跺悕涓? jar銆傚畠鐨勮繍琛岄渶瑕佺敤鍒? JDK 瀹夎鐩綍涓? lib 鐩綍涓殑 tools.jar 鏂囦歡銆備笉榪囨垜浠櫎浜嗗畨瑁? JDK 浠涔堜篃涓嶉渶瑕佸仛錛屽洜涓? SUN 宸茬粡甯垜浠仛濂戒簡銆傛垜浠敋鑷充笉闇瑕佸皢 tools.jar 鏀懼埌 CLASSPATH 涓?nbsp; 闃呰鍏ㄦ枃
]]>
闃呰鍏ㄦ枃
]]>
浼氳瘽宸叉洿鏀廣?/font>
SQL> SELECT TO_DATE('2006-05-01 19:25:34', 'YYYY-MM-DD HH24:MI:SS') FROM DUAL;
TO_DATE('2006-05-01
-------------------
2006-05-01 19:25:34
SQL> SELECT TO_DATE('2006-05-01 19:25', 'YYYY-MM-DD HH24:MI') FROM DUAL;
TO_DATE('2006-05-01
-------------------
2006-05-01 19:25:00
SQL> SELECT TO_DATE('2006-05-01 19', 'YYYY-MM-DD HH24') FROM DUAL;
TO_DATE('2006-05-01
-------------------
2006-05-01 19:00:00
SQL> SELECT TO_DATE('2006-05-01', 'YYYY-MM-DD') FROM DUAL;
TO_DATE('2006-05-01
-------------------
2006-5-1
SQL> SELECT TO_DATE('2006-05', 'YYYY-MM') FROM DUAL;
TO_DATE('2006-05','
-------------------
2006-5-1
SQL> SELECT TO_DATE('2006', 'YYYY') FROM DUAL;
TO_DATE('2006','YYY
-------------------
2006-1-1
褰撶渷鐣?span>HH銆丮I鍜孲S瀵瑰簲鐨勮緭鍏ュ弬鏁版椂錛孫racle浣跨敤0浣滀負DEFAULT鍊箋傚鏋滆緭鍏ョ殑鏃ユ湡鏁版嵁蹇界暐鏃墮棿閮ㄥ垎錛孫racle浼氬皢鏃躲佸垎銆佺閮ㄥ垎閮界疆涓?錛屼篃灝辨槸璇翠細鍙栨暣鍒版棩銆?/span>
鍚屾牱錛屽拷鐣ヤ簡DD鍙傛暟錛孫racle浼氶噰鐢?浣滀負鏃ョ殑榛樿鍊鹼紝涔熷氨鏄浼氬彇鏁村埌鏈堛?/span>
浣嗘槸錛屼笉瑕佽榪欑“
娉ㄦ剰錛?.鍦ㄤ嬌鐢∣racle鐨則o_date鍑芥暟鏉ュ仛鏃ユ湡杞崲鏃訛紝鍙兘浼氱洿瑙夊湴閲囩敤“yyyy-MM-dd HH:mm:ss”鐨勬牸寮忎綔涓烘牸寮忚繘琛岃漿鎹紝浣嗘槸鍦∣racle涓細寮曡搗閿欒錛?#8220;ORA 01810 鏍煎紡浠ｇ爜鍑虹幇涓ゆ”銆傚錛歴elect to_date('2005-01-01 13:14:20','yyyy-MM-dd HH24:mm:ss') from dual;
鍘熷洜鏄疭QL涓笉鍖哄垎澶у皬鍐欙紝MM鍜宮m琚涓烘槸鐩稿悓鐨勬牸寮忎唬鐮侊紝鎵浠racle鐨凷QL閲囩敤浜唌i浠ｆ浛鍒嗛挓銆俿elect to_date('2005-01-01 13:14:20','yyyy-MM-dd HH24:mi:ss') from dual;
2.鍙﹁浠?4灝忔椂鐨勫艦寮忔樉紺哄嚭鏉ヨ鐢℉H24
select to_char(sysdate,'yyyy-MM-dd HH24:mi:ss') from dual;//mi鏄垎閽?br>select to_char(sysdate,'yyyy-MM-dd HH24:mm:ss') from dual;//mm浼氭樉紺烘湀浠?/span>
]]>