SQL Server Performance

Converting to smalldatetime

Discussion in 'SQL Server 2005 Integration Services' started by Lynne, Sep 18, 2006.

  1. Lynne New Member

    Hi, I am using SSIS to migrate from a flat file source to a database. In the source file there is timestamp but the source column expects a smalldatetime, is there a way to covert between these two types?

    Thanks
    Lynne, Sep 18, 2006
    #2

  2. Madhivanan Moderator

    Can you post the sample timestamp value and your expected datetime value?

    Madhivanan

    Failing to plan is Planning to fail
    Madhivanan, Dec 28, 2006
    #2

  3. MohammedU New Member

    If your timestamp is valid datetime column you don't need to explicitely convert it...


    Mohammed U.
    MohammedU, Dec 28, 2006
    #2

  4. mmarovic Active Member

    SmallDateTime accuracy is the minute, if you need better accuracy use dateTime (3.33 miliseconds).

    mmarovic, Dec 29, 2006
    #2

Share This Page