Incorrect syntax when insert date

• Nick081

  Old Hand

  Points: 301

  More actions

  March 20, 2008 at 7:39 am

  #379334

  Hello,

  I'm using the scriptcomponent in SSIS, if I want to insert the date in my table, I'm getting the following error:

  Incorrect syntax near '22'.

  The time output is this: 31/07/2007 22:00:00

  If I use some testdata it only works with the following notation 31/07/200722/00/00

  Is it possible that signs like ":" and spaces are not allowed?

  Thanks in advance!

• Nick081

  Old Hand

  Points: 301

  More actions

  March 20, 2008 at 9:14 am

  #792068

  Nobody who knows how to delete the time from timedate?

  as example 22/07/2007 in stead of 22/07/2007 3:00:33

  Thanks

• Jay1234

  SSCommitted

  Points: 1622

  More actions

  March 20, 2008 at 1:52 pm

  #792228

  To obtain only date part using script component use code below -

  Row.Fieldname = Row.Fieldname.Date