oracle中时间的处理

1. 日期和字符转换函数用法（to_date,to_char）
select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') as nowTime from dual;   //日期转化为字符串  
select to_char(sysdate,'yyyy') as nowYear   from dual;   //获取时间的年  
select to_char(sysdate,'mm')    as nowMonth from dual;   //获取时间的月  
select to_char(sysdate,'dd')    as nowDay    from dual;   //获取时间的日  
select to_char(sysdate,'hh24') as nowHour   from dual;   //获取时间的时  
select to_char(sysdate,'mi')    as nowMinute from dual;   //获取时间的分  
select to_char(sysdate,'ss')    as nowSecond from dual;   //获取时间的秒

 

select to_date('2004-05-07 13:23:44','yyyy-mm-dd hh24:mi:ss')    from dual//

或

  查看哪天的年份
select to_char(to_date('2008-2-29','yyyy-mm-dd'),'year') from dual;    

RESULT：two thousand eight

select to_char(to_date('2008-2-29','yyyy-mm-dd'),'yyyy') from dual;    

RESULT：2008

查看哪天是星期几或几号
select to_char(to_date('2008-2-29','yyyy-mm-dd'),'day') from dual;     

RESULT：星期五

select to_char(to_date('2008-02-29','yyyy-mm-dd'),'day','NLS_DATE_LANGUAGE = American') from dual;
RESULT：friday

select to_char(to_date('2008-2-29','yyyy-mm-dd'),'dd') from dual；

RESULT：29

 

查看两个日期之间的天数
select floor(sysdate - to_date('20080201','yyyymmdd')) from dual;

RESULT：28

 

不比较日期，只去时间段的数据

select * from tb where to_char(sysdate,'hh24mi')>=to_char(DTime,'hh24mi')