·ÇTO_DATE·½Ê½ ÏòORACLEÖвåÈë DATEÀàÐÍ
ÔÚJS²Ù×÷ OracleÊý¾Ý¿âʱ£¬ÓÉÓÚ¿ò¼ÜÔÒò²»ÄÜʹÓà to_dateÃüÁһ³ïĪչ£¬¿´Á˺öà×ÊÁÏ¡£·¢ÏÖÁËÍ»ÆÆ¿Ú¡£
ORACLEÖÐ ÎÞÂÛʲôµ«Èý·½Èí¼þ ¶¼ÊÇÒÔ“Ò»¸ö»á»°(session)”Ϊ»ù´¡½øÐÐһϵÁвÙ×÷µÄ£¬Ö»Òª¹Ø±ÕÕâ¸ö´°¿Ú£¬´Ë»á»°½«±»È¡Ïû/¹Ø±Õ¡£
Òò´ËÏëµ½£¬
alter session set nls_date_format ="yyyy/MM/dd hh24:mi:ss";
Õâ¸öÃüÁîÖ»¶ÔÒ»´Î»á»°ÓÐЧ£¬²¢²»ÊÇÓÀ¾ÃÉúЧ¡£
ÄÇô ¾ÍÔÚ ¿ªÆôÊÂÎñÒÔºó£¬ Ö´ÐÐINSERT֮ǰ£¬Ö´ÐÐÕâÌõÃüÁ
DatabaseManager.beginTransaction();
//½ñ»Ø¤Î¥È¥é¥ó¥¶¥¯¥·¥ç¥ó¤ÎÈÕ¸¶¤ò¥Õ¥©ー¥Þー¥È
var sessionDate = "alter session set nls_date_format = 'yyyy/MM/dd HH24:mi:ss'";
DatabaseManager.execute(sessionDate);
DatabaseManager.insert("tablename",objData);
Ïà¹ØÎĵµ£º
windowsÉÏ´æÔÚ32bitµÄÏÞÖÆ£¬ÈçAIX¡¢HP UNIX µÈÓÐÃ÷È·µÄ64BIT OS and ORACLEµÄ°æ±¾£¬32bit oracle¿ÉÒÔ×°ÔÚ64bit os ÉÏ£¬64 bit oracle²»ÄÜ×°ÔÚ32 bit OSÉÏ
oracleÊÇ64bit or 32 bit,32bit ͨ³£ SGAÓÐ 1.7G µÄÏÞÖÆ(ijЩOSµÄ´¦Àí»òÕßWINDOWSÉÏÓÐÌØ¶¨É趨¿ÉÒÔÖ§³Öµ½2GÒÔÉÏÉõÖÁ´ïµ½3.7G
ÈçºÎ²é³öǰ̨ÕýÔÚ·¢³öµÄsqlÓï¾ä:
sele ......
SQL*PLus> desc emp;
Ãû³Æ &nbs ......
update £ºµ¥±íµÄ¸üв»ÓÃ˵ÁË£¬Á½ÕßÒ»Ñù£¬Ö÷Ҫ˵˵¶à±íµÄ¸üÐÂ
Oracle> OracleµÄ¶à±í¸üÐÂÒªÇó±È½ÏÑϸñ£¬ËùÒÔÓеÄʱºò²»ÊǺܺÃд£¬ÎÒÃÇ¿ÉÒÔÊÔÊÔOracleµÄÓαê
&n ......
MySQL Data Type
Oracle Data Type
BIGINT
NUMBER(19, 0)
BIT
RAW
BLOB
BLOB, RAW
CHAR
CHAR
DATE
DATE
DATETIME
DATE
DECIMAL
FLOAT (24)
DOUBLE
FLOAT (24)
DOUBLE PRECISION
FLOAT (24)
ENUM
VARCHAR2
FLOAT
FLOAT
INT
NUMBER(10, 0)
INTEGER
NUMBER(10, 0)
LONGBLOB
BLOB, RAW
LONGTEX ......
ÓкܶàÓ¦ÓÃÏîÄ¿, ¸ÕÆð²½µÄʱºòÓÃMYSQLÊý¾Ý¿â»ù±¾ÉÏÄÜʵÏÖ¸÷ÖÖ¹¦ÄÜÐèÇó£¬Ëæ×ÅÓ¦ÓÃÓû§µÄÔö¶à£¬Êý¾ÝÁ¿µÄÔö¼Ó£¬MYSQL½¥½¥µØ³öÏÖ²»¿°ÖظºµÄÇé¿ö£º
Á¬½ÓºÜÂýÉõÖÁå´»ú£¬ÓÚÊǾÍÓаÑÊý¾Ý´ÓMYSQLǨµ½ORACLEµÄÐèÇó£¬Ó¦ÓóÌÐòÒ²ÒªÏàÓ¦×öһЩÐ޸ġ£±¾ÈË×ܽá³öÒÔϼ¸µã×¢ÒâÊÂÏϣÍû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
1£® ×Ô¶¯Ôö³¤µÄÊý¾ÝÀàÐ ......