oracle sql 日期处理

得到指定日期的下个月的第一天 

SELECT TO_DATE(TO_CHAR(SYSDATE, 'YYYY/MM'), 'YYYY/MM') + INTERVAL '1' month - 1 / 24 / 60 / 60 / 1000 * 10  
      FROM DUAL;

 

 

  lastDayOfMonth := TO_DATE(SUBSTR(TO_NUMBER(TO_CHAR(tempDate, 'MM')), 1, 2) ||
                            '/01/' ||
                            SUBSTR(TO_NUMBER(TO_CHAR(tempDate, 'YYYY')),
                                   1,
                                   4),
                            'MM/DD/YYYY');
  read_dt        := add_months(lastDayOfMonth,1)-1/24/60;

 

  read_dt_time   := to_timestamp(to_char(read_dt, 'mm/dd/yyyy hh24:mi:ss'),
                                 'mm/dd/yyyy hh24:mi:ss');

 

 

25th 23:59

 

 read_dt := TRUNC(last_DAY(add_months(sysdate, -1)) + 26) - 1 / 24 / 60;

  /** need to uncomment this and comment below when actual proc is to be moved **/
  read_dt_time := to_timestamp(to_char(read_dt, 'mm/dd/yyyy hh24:mi:ss'),
                               'mm/dd/yyyy hh24:mi:ss');