compare date in ssis expressions.

• abhas

  SSCarpal Tunnel

  Points: 4681

  More actions

  November 22, 2013 at 9:02 am

  #285518

  hi all,

  I have lastmodify column in my database and by using that column i need to find out updated records.

  for example lastmodify column contains below time.

  2012-08-07 01:24:10.000

  Now I want to compare above time(lastmodify column) with himself by taking 1 second or 1 milisecond difference. How can i achieve that in SSIS?

  Please help.

  Thanks

  Abhas.

• Phil Parkin

  SSC Guru

  Points: 246977

  More actions

  November 25, 2013 at 12:19 am

  #1668727

  ..compare above time(lastmodify column) with himself...

  What do you mean by this?

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel