oracle日期操作函数

1）增加月份

  select to_char(add_months(sysdate,1),'yyyy-mm') from dual;

2）将当前日期转化为字符串

select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') 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;   //获取时间的秒

 

3） 日期和字符串之间的转换

日期转化为字符串

public String dateToString(Date date)
{
 SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");  
  Date date = new Date();
  return formatter .format(date );
}

字符串转化为日期

public Date StringToDate(String str) throws ParseException
{
  SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");  
  return formatter .parse(str);
}

取两个日期字符串之间的相差天数

  public int compareDate( String Str1,String Str2 ) throws ParseException

  {

    SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");  
    	
    Calendar cal = Calendar.getInstance();    
    cal.setTime(sdf.parse(Str1));    
    long time1 = cal.getTimeInMillis();
    	
    // 当前时间
    cal.setTime(sdf.parse(Str2));    
    long time2 = cal.getTimeInMillis(); long between_days=(time2-time1)/(1000*3600*24); int intDay = Integer.parseInt(String.valueOf(between_days));
    return intDay;
  }