---
title: "oracle 日期和字符转换函数使用"
author: "JavaEEdyc"
date: "2012-04-17T23:21:52Z"
tags: []
categories: ["数据库"]
slug: "oracle"
draft: false
lastmod: "2012-04-17T23:23:23Z"
id: 1488955
url: "https://javaeedyc.iteye.com/blog/1488955"
---

介绍下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