oracle數(shù)據(jù)類型轉(zhuǎn)換to?
To_char:轉(zhuǎn)換成字符串類型,如:To_char(1234.5, '$9999.9'),結(jié)果:$1234.5
To_date:轉(zhuǎn)換成日期類型,如:To_date('1980-01-01', 'yyyy-mm-dd'),結(jié)果:01-1月-80
To_number:轉(zhuǎn)換成數(shù)值類型,如:To_number('1234.5'),結(jié)果:1234.5
oracle數(shù)據(jù)類型轉(zhuǎn)換to?
To_char:轉(zhuǎn)換成字符串類型,如:To_char(1234.5, '$9999.9'),結(jié)果:$1234.5
To_date:轉(zhuǎn)換成日期類型,如:To_date('1980-01-01', 'yyyy-mm-dd'),結(jié)果:01-1月-80
To_number:轉(zhuǎn)換成數(shù)值類型,如:To_number('1234.5'),結(jié)果:1234.5