sql 日期.docVIP

sql 日期 /** * * @param anObject: thisWeek=本周；nextWeek=下周 * @return monday */ public String getMonday(String anObject){ String sql=; String time=; if(thisWeek.equals(anObject)) sql=Select case when to_char(sysdate,D)=1 then to_char(sysdate-to_char(sysdate,D)-5,yyyy-mm-dd) else to_char(sysdate-to_char(sysdate,D)+2,yyyy-mm-dd) end from dual; else if(nextWeek.equals(anObject)) sql= Select case when to_char(sysdate,D)=1 then to_char(sysdate-to_char(sysdate,D)+2,yyyy-mm-dd) else to_char(sysdate-to_char(sysdate,D)+9,yyyy-mm-dd) end from dual; else if(lastWeek.equa