Sql Query Column Value

Question

Hi

I have below code and in some case if it returns 01-01-1900 it should be shown as ''

(SELECT TOP 1 [LastSessionDate] FROM [View_Session_Count_Report] where StudentID = t.StudentId) [LastSessionTDate]

Thanks

Tuhin Paul · Answer

SELECT CASE WHEN (SELECT TOP 1 [LastSessionDate] FROM [View_Session_Count_Report] WHERE StudentID = t.StudentId) = '1900-01-01' THEN '' ELSE (SELECT TOP 1 [LastSessionDate] FROM [View_Session_Count_Report] WHERE StudentID = t.StudentId) END AS [LastSessionTDate] FROM [YourTableName] t Replace [View_Session_Count_Report] with the actual table name, and [YourTableName] with the name of the table you're querying from. The CASE statement checks if the LastSessionDate is equal to '1900-01-01', and if so, it returns an empty string. Otherwise, it returns the actual LastSessionDate.

Vishal Yelve · Answer

(SELECT TOP 1 CASE WHEN [LastSessionDate] = '1900-01-01' THEN ' ' ELSE [LastSessionDate] END AS [LastSessionTDate] FROM [View_Session_Count_Report] WHERE StudentID = t.StudentId) LastSessionTDate

Amit Mohanty · Answer

SELECT TOP 1 CASE WHEN [LastSessionDate] = '1900-01-01' THEN '' ELSE [LastSessionDate] END AS [LastSessionTDate] FROM [View_Session_Count_Report] WHERE StudentID = t.StudentId

Ramco Ramco · Answer

Hi Rupesh It is still showing 01-01-1900 Thanks

Rupesh Kahane · Answer

Try this one SELECT TOP 1 Case when [LastSessionDate] = 01-01-1900 Then '' Else [LastSessionDate] End As [LastSessionDate] FROM [View_Session_Count_Report] where StudentID = t.StudentId) [LastSessionTDate]