Post reply

how to print NULL for datetime column

  • October 16, 2019 at 5:26 pm

    #3689365

    i have a variable called date

    @Date DATETIME = NULL,

    i want to capture this variable into error log information

    set @log =   @Log + '  ,Date: ' + @Date

    but this is not capturing anything.

    i have tried convert(varchar(20),ISNULL(@Date,GETDATE()),110)  it worked ; but i don't want to capture getdate. i want to print NULL.

     

  • October 16, 2019 at 5:36 pm

    #3689376

    Use coalesce to replace the null value

    set @log =   @Log + '  ,Date: ' + coalesce(@Date, 'NULL')

    How to post data/code on a forum to get the best help.

  • October 16, 2019 at 6:03 pm

    #3689383

    I think you want to convert the date to varchar, and if the results is NULL, use the string NULL

    ISNULL(convert(varchar(20),@Date,GETDATE()),110),'NULL')

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply