oracle操作日期的函数,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;

}