Converting to smalldatetime | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Converting to smalldatetime

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
Can you post the sample timestamp value and your expected datetime value? Madhivanan Failing to plan is Planning to fail
If your timestamp is valid datetime column you don’t need to explicitely convert it…
Mohammed U.
SmallDateTime accuracy is the minute, if you need better accuracy use dateTime (3.33 miliseconds).