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