CODEWITHSUNDEEP
sql-serverdatetimeisnull
user3675548
user3675548

Reputation: 685

Error in using isull on datetime column in ms sql server 2008

I am using MS SQL SERVER 2008.

I am trying to fetch date column from database. This value can be null. How can i handle isnull for datetime column in ms sql server 2008? If value is null i want to diasplay as '-' or ' '.

Upvotes: 0

Views: 147

Answers (2)

Jithin Shaji
Jithin Shaji

Reputation: 6073

This may help, please see.

SET DATEFORMAT YMD

DECLARE @DT DATETIME 

SET @DT = '2014-05-26' --GETDATE()
SELECT ISNULL(CONVERT(VARCHAR(10),@DT,105),CAST('-' AS VARCHAR(10)))

SET @DT = null
SELECT ISNULL(CONVERT(VARCHAR(10),@DT,105),CAST('-' AS VARCHAR(10)))

enter image description here

Upvotes: 0

Tim Schmelter
Tim Schmelter

Reputation: 460158

You have to convert the datetime column to varchar, then you can use ISNULL.

SELECT ISNULL(LEFT(CONVERT(VARCHAR, dateTimeColumn, 120), 10), '-') AS DateAsString
FROM dbo.TableName

CAST and CONVERT

Upvotes: 1

Related Questions