é¦å
castä¸æ¯å½æ°ï¼æ¯è½¬æ¢
è¿ç®ç¬¦ï¼å¯ä»¥æä¸ç§ç±»åçæ°æ®è½¬æ¢ä¸ºå¦å¤ä¸ç§æ°æ®
è¯æ³æ ¼å¼ï¼CAST ( expression AS target_type )
to_number æ¯postgresçå
ç½®å½æ°ï¼æ
å符串æ°å转æ¢ææ°åç±»å
è¯æ³æ ¼å¼ï¼TO_NUMBER(string, format)
è¿ä¸ªå½æ°è½¬æ¢çç»ææ¯æ°å¼ç±»åçæ°æ®ï¼ècastå¯ä»¥è½¬ä»»æç±»åçæ°æ®ã