InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 14:18:40 GMT20http://www.sqlservercentral.com/Forums/Topic709162-338-1.aspxThis solves my problem to a major extent. Thank you so much.Mon, 04 May 2009 00:37:43 GMTsidhartha.poobonihttp://www.sqlservercentral.com/Forums/Topic709162-338-1.aspxHello,I am not exactly sure where the issue is.I would expect you could import dates in the DD-MMM-YY format into a DateTime Column without problems.Once in a DateTime Column (or variable) you could use Convert to display in whichever format is necessary e.g.Declare @MyDate DateTimeSelect @MyDate = '15-Apr-09'Print Convert(VarChar(10), @MyDate, 101)Regards,John MarshSun, 03 May 2009 23:25:25 GMTJohn H Marsh http://www.sqlservercentral.com/Forums/Topic709162-338-1.aspxI am inserting a few thousand rows using SSIS package reading from an Excel file. There is one particular column in Excel file that stores the date value in this manner - 15-Apr-09.I need help in converting this date value into this manner - 04/15/2009I tried writing a scalar defined function but had some issues while converting. Any kind of help will be the most appreciated.Thank youSidharthaSun, 03 May 2009 21:50:13 GMTsidhartha.pooboni