Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

OracleÖеÄTo_dateº¯Êý


OracleÖеÄto_date()º¯Êý
to_date()Óë24Ð¡Ê±ÖÆ±íʾ·¨¼°mm·ÖÖÓµÄÏÔʾ£º
Ò»¡¢ÔÚʹÓÃOracleµÄto_dateº¯ÊýÀ´×öÈÕÆÚת»»Ê±£¬ºÜ¶àJava³ÌÐòÔ±Ò²Ðí»áÖ±½ÓµÄ²ÉÓÓyyyy-MM-dd     HH:mm:ss”µÄ¸ñʽ×÷Ϊ¸ñʽ½øÐÐת»»£¬µ«ÊÇÔÚOracleÖлáÒýÆð´íÎ󣺓ORA 01810 ¸ñʽ´úÂë³öÏÖ
    Á½´Î”¡£
    È磺select to_date('2005-01-01 13:14:20','yyyy-MM-dd HH24:mm:ss') from dual;
    Ô­ÒòÊÇSQLÖв»Çø·Ö´óСд£¬MMºÍmm±»ÈÏΪÊÇÏàͬµÄ¸ñʽ´úÂ룬ËùÒÔOracleµÄSQL²ÉÓÃÁËmi´úÌæ
    ·ÖÖÓ¡£
    select to_date('2005-01-01 13:14:20','yyyy-MM-dd HH24:mi:ss') from dual;
¶þ¡¢ÁíÒªÒÔ24СʱµÄÐÎʽÏÔʾ³öÀ´ÒªÓÃHH24
    select to_char(sysdate,'yyyy-MM-dd HH24:mi:ss') from dual;//miÊÇ·ÖÖÓ
    select to_char(sysdate,'yyyy-MM-dd HH24:mm:ss') from dual;//mm»áÏÔʾÔ·ݠ 
    oracleÖеÄto_date²ÎÊýº¬Òå
    1.ÈÕÆÚ¸ñʽ²ÎÊýº¬Òå˵Ã÷  
      D Ò»ÖÜÖеÄÐÇÆÚ¼¸  
      DAY ÌìµÄÃû×Ö£¬Ê¹ÓÿոñÌî³äµ½9¸ö×Ö·û  
      DD ÔÂÖеĵڼ¸Ìì  
      DDD ÄêÖеĵڼ¸Ìì  
      DY ÌìµÄ¼òдÃû  
      IW ISO±ê×¼µÄÄêÖеĵڼ¸ÖÜ  
      IYYY ISO±ê×¼µÄËÄλÄê·Ý  
      YYYY ËÄλÄê·Ý  
      YYY,YY,Y Äê·ÝµÄ×îºóÈý룬Á½Î»£¬Ò»Î»  
      HH Сʱ£¬°´12Сʱ¼Æ  
      HH24 Сʱ£¬°´24Сʱ¼Æ  
      MI ·Ö  
      SS Ãë  
      MM Ô  
      Mon Ô·ݵļòд  
      Month Ô·ݵÄÈ«Ãû  
      W


Ïà¹ØÎĵµ£º

ARCSDE for Oracle Êý¾Ý´æ´¢ÐÎʽΪst_geometry

SELECT sde.st_area(zone) from sde.test1 ORDER BY name;//
SELECT shape from schools ORDER BY name;
SELECT objectid, sde.st_astext(SDE.ST_POINTfromSHAPE(shape,0)) AS points from schools;
SELECT name, sde.st_x (zone) "The X coordinate" from test ; //ÕýÈ·Ö´ÐÐ
SELECT name, sde.st_x (shape)  "The ......

Upgrade Oracle 9i RAC to Oracle 10g RAC

Upgrade Oracle 9i RAC to Oracle 10g RAC
by Vincent Chan
This article provides the procedures for converting Oracle 9i (9.2.0.4) RAC to Oracle 10g (10.2.0.1) RAC on Red Hat Enterprise Linux 3 (RHEL3).
Oracle Database 10g and Oracle Real Application Cluster (RAC) 10g itself, boast many new and ex ......

Oracle RAC 10.2.0.1 Éý¼¶ 10.2.0.4 ¼òµ¥ÃèÊö

ÍÆ¼öcrs°æ±¾¸ßÓÚdb°æ±¾
If you also plan to apply this patch to Oracle Clusterware,
ensure that you apply the patch to Oracle Clusterware before
applying it to Oracle Database. This is because Oracle Clusterware
hould always be at the same or later version as the database.
Éæ¼°µ½Êý¾Ý¿â¶ø²»ÊÇʵÀýµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ