Post reply

datatype to store only date in SSIS

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

  • February 6, 2017 at 10:31 am

    #1926919

    what about cast(datecolumn as date) ?

  • 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

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

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