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 (select FDisplayName_l2 from T_DM_LowConsumablesTREE where fid = store.FTreeID) 组别 ,store.FName_l2 品名  ,  store.CFModel 规格  ,  a.*,b.*,store.CFQty  as 库存  from    CT_DM_LowConsumables store   left join    (

   select  CFLcNumberID , sum(CFQty) 入库数量    from   CT_DM_LowConsumablesIW as iw inner join CT_DM_LowConsumablesIWEntry iwEntry on  iwEntry.fparentid=iw.fid  where   substring( CONVERT(varchar(100), FBizDate , 23),1,7 )='2023-02'  group by CFLcNumberID
    )  a   on   store.fid=a.CFLcNumberID    left join  
   (
   select  CFLcNumberID , sum(CFQty) 出库数量  from   CT_DM_LowConsumablesOW as ow inner join CT_DM_LowConsumablesOWEntry owEntry on  owEntry.fparentid=ow.fid    where   substring( CONVERT(varchar(100), FBizDate , 23),1,7 )='2023-02'  group by CFLcNumberID

    ) b  on  a.CFLcNumberID=b.CFLcNumberID   order by  组别

        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'