ISNULL DATE_TIME

• sql Anand

  SSCommitted

  Points: 1597

  More actions

  November 29, 2011 at 10:25 pm

  #251253

  HI

  in my ssis...i want to compare load_date to create date..but my 1st run my load date is empty

  so that i used isnull function in ssis

  ISNULL(load_date) ? GETDATE() : load_date

  this query i got success

  but i need

  ISNULL(load_date) ? 01/01/1111 : load_date

  so i compare any previous date to my today load_date how to write this condition in ssis

• subbu1

  Hall of Fame

  Points: 3221

  More actions

  November 30, 2011 at 12:38 am

  #1414462

  ISNULL(load_date) ? 01/01/1111 : load_date

  when user load_date is datetime at that time 01/01/1111 is not supported sql server.

  sql server support date starting from 01/01/1753.