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

最新推荐文章于 2023-04-08 19:46:27 发布

原创最新推荐文章于 2023-04-08 19:46:27 发布 · 421 阅读

0 ·

CC 4.0 BY-SA版权

SQL 专栏收录该内容

6 篇文章

订阅专栏

本文介绍了一个SQL查询案例，用于从数据库中筛选特定日期范围内不同医保类型的报销记录，包括省直职工、海口医保、省大金保等。通过CASE语句转换医保类型编码为具体名称，同时连接用户表获取更多信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

	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----------------------