Get date format in DB2 as expression in SSIS

• komal145

  SSCrazy Eights

  Points: 9915

  More actions

  September 15, 2015 at 11:01 am

  #321246

  hi,

  I am working on a ssis package ,where I have date parameters as format below

  "2015-09-01-00.00.00.000000"

  Can anyone please help me to get this date format in TSQl expression in SSIS package?

• hb21l6

  SSCommitted

  Points: 1647

  More actions

  September 15, 2015 at 1:02 pm

  #1826879

  Hi Komal,

  Is it just date format or date and time?

  Example 1

  You could left trim the string.

  Left('2015-09-01-00.00.00.000000',10)

  To get just the date,

  Then to get a date format

  Convert(date time,Left(2015-09-01-00.00.00.000000",10),103)

  Dave