SQL_003_case变换值 的用法 13_CONVERT 【 between 大于等于 小于等于】 查询日期的用法

	select
	(CASE WHEN yiBaoLeiXing='0' THEN '核三'
	WHEN yiBaoLeiXing='1' THEN '省直职工'
	WHEN yiBaoLeiXing='2' THEN '海口医保'
	WHEN yiBaoLeiXing='3' THEN '省大金保'
	WHEN yiBaoLeiXing='5' or yiBaoLeiXing is null THEN '城保'
	WHEN yiBaoLeiXing='6' THEN '三亚医保'
	WHEN yiBaoLeiXing='8' THEN '外省人员'
	ELSE '其他' END) yiBaoLeiXing ,
	 A.true_money,
	 A.shishoujine ,
	 A.FaPiaoH,A.region_id ,
	 A.baoxiao_id ,
	 A.temp_id ,
	 B.MingCheng 
	 from YW_MenZhenNongHeJS A  
	 LEFT JOIN zd_YongHu B  ON A.jiluscr=B.DaiMa   
	 where del=1 and CheXiaoBZ = 0 and zhuangtai='确认补偿'  and  
	 **(CONVERT(varchar(100), A.jiluscrq, 23))  between  '2016-07-22' and '2016-07-30'**

临高网上挂号

            //----------------------wb19_0416_add begin----------------------
            string strSql_日期条件 = "";
            in_cls_request.beginDate = in_cls_request.beginDate.Trim();
            in_cls_request.endDate = in_cls_request.endDate.Trim();
            System.Windows.Forms.Application.DoEvents();
            if (in_cls_request.beginDate == "" && in_cls_request.endDate == "")
            {
                strSql_日期条件 = "";
            }
            else if (in_cls_request.beginDate == "" && in_cls_request.endDate != "")
            {
                strSql_日期条件 = string.Format(@" and (CONVERT(varchar(100), A.CreatTime, 23)) <= '{0}' ", in_cls_request.endDate);
            }
            else if (in_cls_request.beginDate != "" && in_cls_request.endDate == "")
            {
                strSql_日期条件 = string.Format(@" and (CONVERT(varchar(100), A.CreatTime, 23)) >= '{0}' ", in_cls_request.beginDate);
            }
            else
            {
                strSql_日期条件 = string.Format(@" and (CONVERT(varchar(100), A.CreatTime, 23)) between '{0}' and '{1}' ", in_cls_request.beginDate, in_cls_request.endDate);
            }

            System.Windows.Forms.Application.DoEvents();
            //----------------------wb19_0416_add end----------------------