用例将日期转换为文本以显示null

发布于 2025-02-13 02:00:03 字数 1221 浏览 1 评论 0原文

首先，我是一个SQL婴儿，所以请耐心等待我。我正在尝试查询一张桌子上有放电日期的桌子。我想显示出排出原因或日期为null的记录。当我编写查询时，我尝试了一个案例语句和在哪里确定任何案例。运行查询时我没有结果。

/****** selectTopnrows命令的脚本来自ssms ******/ 选择[Eockey]

-- ,[Division Code]
-- ,[Division]
,[FacilityOrgKey]
,[Facility Code]
,[Facility Name]
,[DMH ID]
,[Consumer Full Name]
,[Open Admission]
--,[ProviderSiteOrgKey]
--,[Provider Site]
,[Local Chart Number]
--,[Initial Contact Date]
,[Admission Date]
,[Admission Reason Code]
--  ,[Admission Reason]
,[Admission Comment]
--  ,[Referral Source Code]
,[Referral Source]
--  ,[ReferralOfficeOrgKey]
--  ,[Referral Office]
,[Discharge Date]
,[Discharge Reason Code]
,[Discharge Reason]
,[Discharge Comment]
-- ,[Follow Up Type Code]
--  ,[Follow Up Type]
--  ,[Referral Given]
--  ,[ReferredToOrgKey]
--  ,[Referred To]
--   ,[Date Added]
--   ,[Added By]
--   ,[Date Modified]
--  ,[Modified By]
--  ,[DivisionKey]
--  ,[EOCAdmissionReasonKey]
--  ,[EOCDischargeReasonKey]
--  ,[EOCFollowupTypeKey]
--  ,[ReferralSourceTypeKey]
--case when convert(DATE, Discharge Date) is Null then '' End as [DC Date]  

FROM [Data_Central].[CIMOR].[EpisodeOfCare]
Where [Facility Code] in ('005','009','026')
and [Discharge Reason] like '%Null%'

原文

First I am a SQL baby so please be patient with me. I am trying to query a table with discharge dates in the table. I want to display records where Discharge Reason or date is null. When I write the query I tried both a case statement and where statement to identify any cases. I get no results when I run the query.

/****** Script for SelectTopNRows command from SSMS ******/
SELECT [EOCKey]

-- ,[Division Code]
-- ,[Division]
,[FacilityOrgKey]
,[Facility Code]
,[Facility Name]
,[DMH ID]
,[Consumer Full Name]
,[Open Admission]
--,[ProviderSiteOrgKey]
--,[Provider Site]
,[Local Chart Number]
--,[Initial Contact Date]
,[Admission Date]
,[Admission Reason Code]
--  ,[Admission Reason]
,[Admission Comment]
--  ,[Referral Source Code]
,[Referral Source]
--  ,[ReferralOfficeOrgKey]
--  ,[Referral Office]
,[Discharge Date]
,[Discharge Reason Code]
,[Discharge Reason]
,[Discharge Comment]
-- ,[Follow Up Type Code]
--  ,[Follow Up Type]
--  ,[Referral Given]
--  ,[ReferredToOrgKey]
--  ,[Referred To]
--   ,[Date Added]
--   ,[Added By]
--   ,[Date Modified]
--  ,[Modified By]
--  ,[DivisionKey]
--  ,[EOCAdmissionReasonKey]
--  ,[EOCDischargeReasonKey]
--  ,[EOCFollowupTypeKey]
--  ,[ReferralSourceTypeKey]
--case when convert(DATE, Discharge Date) is Null then '' End as [DC Date]  

FROM [Data_Central].[CIMOR].[EpisodeOfCare]
Where [Facility Code] in ('005','009','026')
and [Discharge Reason] like '%Null%'

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

裂开嘴轻声笑有多痛 2025-02-20 02:00:03

您可以直接使用为null-

SELECT 
   * 
FROM [Data_Central].[CIMOR].[EpisodeOfCare]
Where 
     [Facility Code] in ('005','009','026') 
     and ([Discharge Reason] IS NULL OR [DATE] IS NULL)

You can directly use IS NULL -

SELECT 
   * 
FROM [Data_Central].[CIMOR].[EpisodeOfCare]
Where 
     [Facility Code] in ('005','009','026') 
     and ([Discharge Reason] IS NULL OR [DATE] IS NULL)

回复收藏 0 原文

~没有更多了~