how to print NULL for datetime column

• mcfarlandparkway

  SSCertifiable

  Points: 7701

  More actions

  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.

   

• DesNorton

  SSC-Insane

  Points: 24498

  More actions

  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.

• Lowell

  SSC Guru

  Points: 323522

  More actions

  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!