datatype to store only date in SSIS

  • 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]

  • what about cast(datecolumn as date) ?

  • 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.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply