oracle 日期和字符转换函数使用

那梓珊

介绍下oracle中：日期和字符转换函数用法（to_date,to_char）
看了下面的例子知道作用了。很好用！


SQL> select hiredate from emp;

HIREDATE
-----------
1980/12/17
1981/2/20
1981/2/22
1981/4/2
1981/9/28
1981/5/1
1981/6/9
1987/4/19
1981/11/17
1981/9/8
1987/5/23
1981/12/3
1981/12/3
1982/1/23
1981/4/2
1981/12/2
....................................................................
SQL> select hiredate,to_char(hiredate,'yyyy/mm/dd hh24:mi:ss') from emp
  2   where hiredate  >=to_date('19810417','yyyymmdd');

HIREDATE    TO_CHAR(HIREDATE,'YYYY/MM/DDHH
----------- ------------------------------
1981/9/28   1981/09/28 00:00:00
1981/5/1    1981/05/01 00:00:00
1981/6/9    1981/06/09 00:00:00
1987/4/19   1987/04/19 00:00:00
1981/11/17  1981/11/17 00:00:00
1981/9/8    1981/09/08 00:00:00
1987/5/23   1987/05/23 00:00:00
1981/12/3   1981/12/03 00:00:00
1981/12/3   1981/12/03 00:00:00
1982/1/23   1982/01/23 00:00:00
1981/12/2   1981/12/02 00:00:00