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
  2. Madhivanan Moderator

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

    Madhivanan

    Failing to plan is Planning to fail
  3. MohammedU New Member

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


    Mohammed U.
  4. mmarovic Active Member

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

Share This Page