Using ISNULL with a Convert

• in2nat

  SSC Veteran

  Points: 268

  More actions

  June 6, 2005 at 9:26 pm

  #362876

  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.

• padmakumar_pga

  Right there with Babe

  Points: 766

  More actions

  June 6, 2005 at 9:59 pm

  #563386

  hi

  Select

  CONVERT(varchar(12), isnull(n.TestDateTime,''),103)  from Table

   

  Regards

  padmakumar

• ron k

  SSCertifiable

  Points: 6103

  More actions

  June 7, 2005 at 8:52 am

  #563564

  I get '1/1/1900' for null dates using that suggestion.  I think this does the trick.

  ---

  declare @testdate datetime

  set @testdate = getdate()

  Select Isnull(CONVERT(varchar(12), @TestDate,101),'') as MyDate

  set @testdate = null

  Select Isnull(CONVERT(varchar(12), @TestDate,101),'') as MyDate

  MyDate      

  ------------

  06/07/2005

  (1 row(s) affected)

  MyDate      

  ------------

  (1 row(s) affected)

  ---