Converting DateTime

• in2nat

  SSC Veteran

  Points: 268

  More actions

  June 6, 2005 at 8:35 pm

  #167153

  I need to convert the DateTime from a table.  So far have this...

  CONVERT(varchar, n.TestDateTime)

  There maybe null values so this is returning nothing well I run my script.  I know I have to use ISNULL but are unsure as to where on this line of code to place it.

  Any help would be greatly appreciated.

   

   

   

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  June 6, 2005 at 9:33 pm

  #563383

  SELECT ISNULL(CONVERT(varchar, n.TestDateTime),getdate())...

  substitute getdate() with whatever you want it to return if value is NULL.

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**