如何从表中获取数据仅限日期？目前它明智地给出了日期时间 [英] how to get data from table only date wise? currently it is giving date time wise

问题描述

大家好，

这是一个查询，我在我的存储过程中使用..我从表日期明智地获取值，但它明智地给了我日期时间..

  SELECT  Last_Date，
  CASE   WHEN  ParameterId =  3  那么结果 END   AS  BPLaw，
  CASE   WHEN  ParameterId =  4  那么结果 END   AS  BPHigh 
  FROM  patient_progress_tracking_details 
  WHERE  Patient_Id =  132  
  AND  Tenant_Id =  1  
  AND  Branch_Id =  1  
  AND  Last_Date  BETWEEN  '  2012-11-01'  AND  '  2013-11-31' 
  group   by  Last_Date; 

我的输出我得到的是：

Last_Date BPLaw BPHigh

11/16/2012 10:30:57 AM Null 120

11/16/2012 06 ：23：57 AM 65 null





我希望结果列在一列日期...

解决方案

尝试类似下面的内容：

  SELECT   CONVERT （ VARCHAR （ 10 ），Last_Date， 103 ） as  Last_Date，
  CASE   WHEN  ParameterId =  3  那么结果 END   AS  BPLaw，
  CASE   WHEN  ParameterId =  4  那么结果 END   AS  BPHigh 
  FROM  patient_progress_tracking_details 
  WHERE  Patient_Id =  132  
  AND  Tenant_Id =  1  
  AND  Branch_Id =  1  
  AND  Last_Date  BETWEEN  '  2012-11-01'  AND  '  2013-11-31' 
  GROUP   BY   CONVERT （ VARCHAR （ 10 ），Last_Date， 103 ）

您好，



您可以使用 UNION 来得到你想要的结果。

你可以按照下面的方式写下查询。

  SELECT  Last_Date，
  CASE   WHEN  ParameterId =  3  那么结果 END   AS  BPLaw，
 ' '  AS  BPHigh 
  FROM  patient_progress_tracking_details 
  WHERE  Patient_Id =  132  
  AND  Tenant_Id =  1  
  AND  Branch_Id =  1  
  AND  Last_Date  BETWEEN  '  2012-11-01   AND  '  2013-11-31' 
  group   by  Last_Date; 
 
  UNION  
 
  SELECT  Last_Date，
 ' '  AS  BPLaw，
  CASE   WHEN  ParameterId =  4  那么结果 END   AS  BPHigh 
  FROM  patient_progress_tracking_details 
  WHERE  Patient_Id =  132  
  AND  Tenant_Id =  1  
  AND  Branch_Id =  1  
  AND  Last_Date  BETWEEN  '  2012-11-01'  AND  < span class =code-string>'  2013-11-31' 
  group   by  Last_Date; 

我希望它会对你有所帮助

hi to all,
Here is a query which is I am using in my stored procedure.. I am fetching values from table date wise but it is giving me date time wise..

SELECT Last_Date,
 CASE WHEN ParameterId = 3 THEN Result END AS BPLaw,
 CASE WHEN ParameterId = 4 THEN Result END AS BPHigh
        FROM patient_progress_tracking_details
       WHERE     Patient_Id = 132
             AND Tenant_Id = 1
             AND Branch_Id = 1
             AND Last_Date BETWEEN '2012-11-01' AND '2013-11-31' 
             group by  Last_Date ;

the output which I am getting is:
Last_Date BPLaw BPHigh
11/16/2012 10:30:57 AM Null 120
11/16/2012 06:23:57 AM 65 null


I want both the result in a single column datewise...

解决方案

try something like below :

SELECT CONVERT(VARCHAR(10),Last_Date,103)as Last_Date,
 CASE WHEN ParameterId = 3 THEN Result END AS BPLaw,
 CASE WHEN ParameterId = 4 THEN Result END AS BPHigh
        FROM patient_progress_tracking_details
       WHERE     Patient_Id = 132
             AND Tenant_Id = 1
             AND Branch_Id = 1
             AND Last_Date BETWEEN '2012-11-01' AND '2013-11-31'
             GROUP BY  CONVERT(VARCHAR(10),Last_Date,103)

Hi,

you can use the UNION to get your desired result.
you can write the query following way.

SELECT Last_Date,
 CASE WHEN ParameterId = 3 THEN Result END AS BPLaw,
 '' AS BPHigh
        FROM patient_progress_tracking_details
       WHERE     Patient_Id = 132
             AND Tenant_Id = 1
             AND Branch_Id = 1
             AND Last_Date BETWEEN '2012-11-01' AND '2013-11-31' 
             group by  Last_Date ;

UNION

SELECT Last_Date,
 '' AS BPLaw,
 CASE WHEN ParameterId = 4 THEN Result END AS BPHigh
        FROM patient_progress_tracking_details
       WHERE     Patient_Id = 132
             AND Tenant_Id = 1
             AND Branch_Id = 1
             AND Last_Date BETWEEN '2012-11-01' AND '2013-11-31' 
             group by  Last_Date ;

I hope it will be help you.

这篇关于如何从表中获取数据仅限日期？目前它明智地给出了日期时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！