convert string to datetime - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

convert string to datetime

Author

Topic

maihabib
Starting Member

22 Posts

Posted - 2013-12-17 : 06:48:28

I have a string formatted as 2011-11-10 14:30:30.000 and I want to insert it in sql table datetime column.
I’m using derived column in ssis 2005
How shall I write the expression please

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-12-17 : 07:51:28

Duplicate of

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=190339

Please dont cross post

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources