oracleÖÐÔõô½«intÀàÐÍת»»stringÀàÐÍ

ʱ¼ä£º2020.05.05 ·¢²¼ÈË£ºyyy52099yyy

oracleÖÐÔõô½«intÀàÐÍת»»stringÀàÐÍ

Òѽâ¾öÎÊÌâ

¹È¸èyyy52099yyyÓû§ÔÚ2020.05.05Ìá½»Á˹ØÓÚ¡°Ó¢ÀÊoracleÖÐÔõô½«intÀàÐÍת»»stringÀàÐÍ¡±µÄÌáÎÊ£¬»¶Ó­´ó¼ÒÓ¿Ô¾·¢±í×Ô¼ºµÄ¹Ûµã¡£Ä¿Ç°¹²ÓÐ1¸ö»Ø´ð£¬×îºó¸üÐÂÓÚ2025-03-01T15:40:56¡£Ï£Íû´ó¼ÒÄܹ»°ïÖúËý¡£

ÏêϸÎÊÌâÃèÊö¼°ÒÉÎÊ£ºÆÚ´ýÄúµÄ´ð°¸£¬ÎÒ²»ÖªµÀ˵ʲô²ÅºÃ,³ýÁËлл £¡

Ï£ÍûÒÔϵĻشð£¬Äܹ»°ïÖúÄã¡£

µÚ1¸ö»Ø´ð

Óû§Ãû£ºÄäÃûÓû§  

½«intÀàÐÍת»»stringÀàÐÍ·½·¨ÈçÏ£º

selectCAST(A.xxxASCh**AR)asxxx,A.zzzfromAwherA.yyy='123';

OracleµÄÈý´óÀàÐÍת»»£º

1¡¢Ê¹ÓÃto_char(ÈÕÆÚ,¡®¸ñ¡°³£Á¿¡±Ê½')º¯Êý½«ÈÕÆÚת³É×Ö·û´®£º

Àý1£ºÏÔʾÈçϸñʽ£º2018Äê05ÔÂ10ÈÕÐÇÆÚËÄ

selelctto_char(sysdate,ÎÊ´ð'yyyy"Äê"mmÔ¸¼¯°²Ö±ÃËÎïÂÔÏû³¡²é"ÔÂ"dd"ÈÕ"day'ÑôÒâ);

Àý2£ºÏÔʾ¸ñʽÔËÉýÈÎÆøÍ¬¹Ê£º2015-04-25½ñÌìÊÇÐÇÆÚÁù15:15:15

selectto_char(sysdate,'yy±øyy-mm-dd"½ñÌìÊÇ"dayhh24:mi:ss');

2¡¢Ê¹ÓÃto_char(ÊýÖµ£¬¸ñʽ)º¯Êý½«Êýֵת³É×Ö·û´®¡£

Àý1£ºÏÔʾ¸ñʽ£º$1,234

selectto_char(1234,'$9,999')fromclual;

Àý2£ºÏÔʾ¸ñʽ£º£¤1,234

selectto_char(1234,'L9,999')fromclual;

3¡¢Ê¹ÓÃto_char('×Ö·û´®','¸ñʽ')º¯Êý£¬½«×Ö·û´®×ª³ÉdateÀàÐÍ£º

±±µôÖ¯¹ÛȨÀý£ºchax1980Äê12ÔÂ17ÈÕÈëÖ°µÄÔ±¹¤

select*fromemp

wherehiredate=todate('1980»ò»µËäΰÇàÕÆÄê12ÔÂ17ÈÕ','yyyy"Äê"mm"ÔÂ"dd"ÈÕ"');

4¡¢Ê¹ÓÃto_number('×Ö·û´®')º¯Êý½«×Ö·û´®×ª³ÉÊý×Ö¡£

À©Õ¹**

Oracleº¯ÊýµÄ¹¤×÷·½Ê½ÓÐÁ½ÖÖ£º

1¡¢¸üÊýµÄÇú×å¸ù¾Ý¾ÉµÄ¶ÔÏó´´½¨ÐµĶÔÏ󡪡ªËûÃǶÔÔ­À´µÄÐÅÏ¢½øÐÐÐ޸ģ¬Èç¸Ä±ä×ÖĸµÄ´óСд¡£

2¡¢¸æËßÓû§ÓйصÄÐÅÏ¢£¬ÈçÒ»¸öµ¥´Ê»ò¾ä×ÓÖÐÓм¸¸ö×Ö·û¡£

OracleÖÐÖ÷ÒªÓÐÁ½ÖÖ×Ö·û´®ÀàÐÍ£ºCh**ARºÍVARCh**AR2£¬ËûÃÇÒÔ×Öĸ£¬±êµã£¬Êý×ÖѸÖð²Ë¶îºÍ¿Õ¸ñµÄ»ìºÏÐÎʽ»­Í£ÒôËõ´æÔÚ¡£

Ch**AR´®Ê¼ÖÕΪ¶¨³¤µÄ£¬Èç¹ûÉèÖõÄÖ**¤¶ÈСÓÚCh**ARÁеĴ®Öµ£¬»á×Ô¶¯Ìî³ä¿Õ¸ñÕÔºÜËï¡£ÔڱȽÏCh**AR´®Ê±£¬»áΪ˫·½¶¼²¹Âú¿Õ¸ñºóÔÙ½øÐбȽϡ£

VARCh**AR2Êý¾ÝÀàÐÍΪ±ß³¤µÄ´®£¨VARCh**ARÓëVARCh**AÒËÑÏÊ×Ë¿ÈÈR2ΪͬÒå´Ê£©¡£