datatype to store only date in SSIS

  • sql_learner29

    SSCrazy Eights

    Points: 9107

    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

    what about cast(datecolumn as date) ?

  • Thom A

    SSC Guru

    Points: 98622

    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