datatype to store only date in SSIS

• sql_learner29

  SSCrazy Eights

  Points: 9107

  More actions

  October 6, 2008 at 7:53 pm

  #125937

  Hi all,

  Is there any date datatype in SSIS, that will only store date part of a datetime column, I dont want to use convert i just want date datatype...

  Is there any in SQL server...that i can use while creating table..????????

  Thanks

  [font="Comic Sans MS"]
  ---------------------------------------------------

  Thanks [/font]

• nhapzz

  SSC Enthusiast

  Points: 144

  More actions

  February 6, 2017 at 10:31 am

  #1926919

  what about cast(datecolumn as date) ?

• Thom A

  SSC Guru

  Points: 99137

  More actions

  February 6, 2017 at 10:40 am

  #1926925

  nhapzz - Monday, February 6, 2017 10:31 AM

  what about cast(datecolumn as date) ?

  OP has Posted in the SQL Server 2005 forum. The Datatype DATE wasn't introduced until SQL Server 2008. There is no date (only) data type in SQL server 2005, unless I recall incorrectly.

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk