转换函数Oracle

转换函数
1.隐性
date转varchar2转number
select ‘12’ + 2 from dual
输出

14
显性
见Word文档
date和character的转换
select employed_id,hire_date from employes
–where hire_date=‘7-6月-94’
–where to_cher(hire_date,‘yyyy-mm-dd’)=‘1994-06-07’
–where to_date(‘1997-06-07’,‘yyyy-mm-dd’)=hire_date
–where to_cher(hire_date,‘yyyy/mm/dd’)=‘1994/06/07’
–where to_cher(hire_date,‘yyyy/mm/dd’)=‘1994/06/07’
需要穿插字符在里面加双引号
select employed_id,to_cher(hire_date,‘yyyy"年"mm”月"dd"日"’) from employes
–where to_cher(hire_date,‘yyyy"年"mm”月"dd"日"’)=‘1994年06月07日’

character和number之间的转换
select to_char(123456.789,‘999,999,999.999’) from dual
select to_char(123456.789,‘L999,999,999.999’) from dual
local L可换成其他字符

select to_number(‘L999,999,999.999’，123456.789) from dual
字符转数字