oracleÈ¡³öʱ¼äµÄÎÊÌâ
ÎÒ°ÑÒ»¸öʱ¼äÀàÐ͵ÄÊý¾Ý¼¯´ÓoracleÖÐÈ¡³ö£¬¿ÉÊǸñʽΪ2010-3-2 10£º25£º28 ¿ÉÊÇÎÒÏë°ÑÈ¡³öµÄ¸ñʽ±ä³ÉÕâÑùµÄ£º2010-03-02 10£º25£º28 ÇëÎʸÃÔõô×ö£¿
ÄãÒªÊÇÏëÏÔʾµÄÊÇstringµÄÄÇ2¸ö0 Äã¿ÉÒÔ×Ô¼ºÅжÏÌí¼Ó º¹~ÒýÓà ÄãÒªÊÇÏëÏÔʾµÄÊÇstringµÄÄÇ2¸ö0 Äã¿ÉÒÔ×Ô¼ºÅжÏÌí¼Ó º¹~ Èç¹û²»ÓÃÅжϵģ¬Äܲ»ÄÜÈ¡³öÕâÖÖ¸ñʽµÄ£¿ Convert.ToDateTime(ʱ¼ä×Ö·û´®).ToString("yyyy-MM-dd HH:mm:ss") ToString("yyyy-MM-dd hh:mm:ss") ÒýÓà ÒýÓà 1 Â¥ chengcheng1253 µÄ»Ø¸´: ÄãÒªÊÇÏëÏÔʾµÄÊÇstringµÄÄÇ2¸ö0 Äã¿ÉÒÔ×Ô¼ºÅжÏÌí¼Ó º¹~ Èç¹û²»ÓÃÅжϵģ¬Äܲ»ÄÜÈ¡³öÕâÖÖ¸ñʽµÄ£¿ ÎÒ»¹ÏëÇëÎÊÏ£¬datetime? ¸údatetimeÓÐʲô²»Ò»ÑùµÄ£¬ÄǸöÎʺűíʾʲôÒâ˼£¿ ²»¶®Â¥ÉÏÔÚÎÊʲôÁË£¿£¿ÒýÓà ÒýÓà 2 Â¥ sll347 µÄ»Ø¸´: ÒýÓà 1 Â¥ chengcheng1253 µÄ»Ø¸´: ÄãÒªÊÇÏëÏÔʾµÄÊÇstringµÄÄÇ2¸ö0 Äã¿ÉÒÔ×Ô¼ºÅжÏÌí¼Ó º¹~ Èç¹û²»ÓÃÅжϵģ¬Äܲ»ÄÜÈ¡³öÕâÖÖ¸ñʽµÄ£¿ ÎÒ»¹ÏëÇëÎÊÏ£¬datetime? ¸údatetimeÓÐʲô²»Ò»ÑùµÄ£¬ÄǸöÎʺűíʾʲôÒâ˼£¿ ÄãµÄÎÊÌâÌ«¶àÁË£¬ºÇºÇ £¿±íʾ¿É¿ÕÀàÐÍ¡£Èç int? id; Õâ¸öÔÚʵÌåÀàÖо³£ÓС£ oracleÀï×Ô¼º¾Í¿ÉÒÔת»» Select TO_CHAR(ÈÕÆÚ×Ö¶Î,'YYYY-MM-DD HH:MI:SS') from yourtable ²»¹ýÈ¡³öºó¾ÍÊÇ×Ö·ûÐ͵ÄÁË£¬Èç¹ûÄãÖ»ÒªÏÔʾ²»×ö½øÒ»²½µÄ´¦Àí£¬¿ÉÒÔÖ±½ÓÕâÑùÓÃ
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ ÒýÓà ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
Á½¸öÎļþ1.PC£¬1.inc 1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
oracle 11g °²×° 01092 ´íÎó, ÈÕÖ¾ÐÅÏ¢£º [oracle@linux trace]$ vi alert_orcl.log MMON started with pid=14, OS id=9089 RESETLOGS after incomplete recovery UNTIL CHANGE 522752 Errors in file / ......
eclipse 3.3Æô¶¯web¹¤³Ì£¬ÒªÁ¬½Óoracle9iÊý¾Ý¿â±¨ ÑÏÖØ: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error: ORA-12518, TNS:listener could not hand off cli ......