sqlserver 日期判断 日期修改

 oracle  和  sqlserver 计算日期查的语法

//sqlserver 语法------
String format = new SimpleDateFormat("yyyy-MM-dd").format(new Date());
   sql.append("where datediff(day,a.FBIZDate,'").append(format).append("')=0\n");
      //oracle 语法--------
   sql.append("where TO_NUMBER(to_date(to_char(a.FBIZDATE, 'yyyy-mm-dd'), 'yyyy-mm-dd')- TO_DATE('"+format+"','yyyy-mm-dd'))=0    \n");   




  StringBuffer sql = new StringBuffer("/*dialect*/select a.CFBatch from CT_HW_TempInWarehsBill a\n");
//      sql.append("inner join CT_HW_TempInWarehsBillEntry b on a.fid = b.fparentid\n");
      //sqlserver 语法------
       sql.append("where datediff(day,a.FBIZDate,'").append(format).append("')=0\n");
      //oracle 语法--------
     // sql.append("where TO_NUMBER(to_date(to_char(a.FBIZDATE, 'yyyy-mm-dd'), 'yyyy-mm-dd')- TO_DATE('"+format+"','yyyy-mm-dd'))=0    \n");
      sql.append("and a.CFAdminOrgId='").append(SysContext.getSysContext().getCurrentAdminUnit().getId()).append("'\n");
      sql.append("and a.CFBatch is not null\n");
      sql.append("order by a.CFBatch desc");
      IRowSet rs = SQLExecutorFactory.getRemoteInstance(sql.toString()).executeSQL();

select * from CT_HW_RevenueAffirm where    FBIZDATE   between  '2021-01-26'  AND   '2021-02-25' 
               

   update   CT_HW_RevenueAffirm   set  FBIZDATE='2021-02-28'   where    FBIZDATE   between  '2021-01-26'  AND   '2021-02-25'