Óû§Ãû£ºÄäÃûÓû§
½«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ΪͬÒå´Ê£©¡£