SQLServerCentral / SQL Server 2008 / SQL Server 2008 - General / How would you convert this date in SSIS or after lodaed in database 2007-02-20 05:20:36.449923 / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 12:25:17 GMT20RE: How would you convert this date in SSIS or after lodaed in database 2007-02-20 05:20:36.449923http://www.sqlservercentral.com/Forums/Topic1378545-391-1.aspxIn a DerivedColumn transaformation Editor, you would use, e.g.[code="sql"](DT_DBTIMESTAMP2, 7)@[User::DateVar][/code]Wed, 31 Oct 2012 00:59:32 GMTStewart "Arturius" CampbellRE: How would you convert this date in SSIS or after lodaed in database 2007-02-20 05:20:36.449923http://www.sqlservercentral.com/Forums/Topic1378545-391-1.aspxConvert to a date or date timedatetime2 ??? will look that up.Tue, 30 Oct 2012 09:11:48 GMTJonathan MarshallRE: How would you convert this date in SSIS or after lodaed in database 2007-02-20 05:20:36.449923http://www.sqlservercentral.com/Forums/Topic1378545-391-1.aspxya convert it to what ??it looks like datetime2 ...Tue, 30 Oct 2012 02:39:31 GMTdemonfoxRE: How would you convert this date in SSIS or after lodaed in database 2007-02-20 05:20:36.449923http://www.sqlservercentral.com/Forums/Topic1378545-391-1.aspxConvert it to what?Tue, 30 Oct 2012 02:17:42 GMTStewart "Arturius" CampbellHow would you convert this date in SSIS or after lodaed in database 2007-02-20 05:20:36.449923http://www.sqlservercentral.com/Forums/Topic1378545-391-1.aspxHave google a lot of different formats and I must be missing something. How would one look to convert this format...?2007-02-20 05:20:36.449923Mon, 29 Oct 2012 20:52:12 GMTJonathan Marshall