oracleÈ¡³öʱ¼äµÄÎÊÌâ
ÎÒ°ÑÒ»¸öʱ¼äÀàÐ͵ÄÊý¾Ý¼¯´ÓoracleÖÐÈ¡³ö£¬¿ÉÊǸñʽΪ2010-3-2 10£º25£º28
¿ÉÊÇÎÒÏë°ÑÈ¡³öµÄ¸ñʽ±ä³ÉÕâÑùµÄ£º2010-03-02 10£º25£º28
ÇëÎʸÃÔõô×ö£¿
ÄãÒªÊÇÏëÏÔʾµÄÊÇstringµÄÄÇ2¸ö0 Äã¿ÉÒÔ×Ô¼ºÅжÏÌí¼Ó º¹~
Èç¹û²»ÓÃÅжϵģ¬Äܲ»ÄÜÈ¡³öÕâÖÖ¸ñʽµÄ£¿
Convert.ToDateTime(ʱ¼ä×Ö·û´®).ToString("yyyy-MM-dd HH:mm:ss")
ToString("yyyy-MM-dd hh:mm:ss")
ÎÒ»¹ÏëÇëÎÊÏ£¬datetime? ¸údatetimeÓÐʲô²»Ò»ÑùµÄ£¬ÄǸöÎʺűíʾʲôÒâ˼£¿
²»¶®Â¥ÉÏÔÚÎÊʲôÁË£¿£¿
ÄãµÄÎÊÌâÌ«¶àÁË£¬ºÇºÇ
£¿±íʾ¿É¿ÕÀàÐÍ¡£Èç int? id; Õâ¸öÔÚʵÌåÀàÖо³£ÓС£
oracleÀï×Ô¼º¾Í¿ÉÒÔת»»
Select TO_CHAR(ÈÕÆÚ×Ö¶Î,'YYYY-MM-DD HH:MI:SS') from yourtable
²»¹ýÈ¡³öºó¾ÍÊÇ×Ö·ûÐ͵ÄÁË£¬Èç¹ûÄãÖ»ÒªÏÔʾ²»×ö½øÒ»²½µÄ´¦Àí£¬¿ÉÒÔÖ±½ÓÕâÑùÓÃ
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......