Sql Query Column Value

Ramco Ramco

3y1.1kSQL

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tuhin Paul3y ago
```
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.
0
Vishal Yelve3y ago
(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
0

Amit Mohanty3y ago

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 Ramco3y ago
Hi Rupesh

It is still showing 01-01-1900

Thanks
0
Rupesh Kahane3y ago
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]
0