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
Ïà¹ØÎĵµ£º
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
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 ......
ÍÆ¼ö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.
Éæ¼°µ½Êý¾Ý¿â¶ø²»ÊÇʵÀýµ ......