InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 02:09:09 GMT20http://www.sqlservercentral.com/Forums/Topic1422494-1292-1.aspxbitbucket is the hero here, and well done with the example.And by the way do not hesitate to ask questions as needed in the future. There is help hereM.Thu, 21 Feb 2013 14:05:02 GMTMiles Nealehttp://www.sqlservercentral.com/Forums/Topic1422494-1292-1.aspxGuys, you are my heroes of the day. It now works.. so far, let's hope it keeps going like that !Thank you very much, I will probably need your help again, so keep coming around sometimes :-PThu, 21 Feb 2013 13:52:00 GMTkanoe82http://www.sqlservercentral.com/Forums/Topic1422494-1292-1.aspxThanks for your help.I understand your solution, but I have 4 sources that I have to join, so there's a lot of datas, not just 3 or 4. With your solution, I have to do value by value ans that is not possible.Is this possible to make it automatic after the extraction and before the loading?Thu, 21 Feb 2013 13:17:03 GMTkanoe82http://www.sqlservercentral.com/Forums/Topic1422494-1292-1.aspxHERE it is from a table (Now I used a temporary table BUT ONLY for illustration IN your situation it would be the real table)[code="sql"] /* I used a temporary table BUT ONLY for illustration the values I used are from your posting Posted Today @ 6:13 AM */ CREATE TABLE #T (D VARCHAR(20)) INSERT INTO #T(D) VALUES ('01/12/2012'),('03/Dec/2012'),('01/01/13') SELECT D as 'Input value', CAST(D AS DATE) AS 'Output' FROM #TResultsInput value Output01/12/2012 2012-01-1203/Dec/2012 2012-12-0301/01/13 2013-01-01[/code]With your new data:[code="sql"] CREATE TABLE #T (D VARCHAR(20)) INSERT INTO #T(D) VALUES ('01/12/2012'),('03/Dec/2012'),('01/01/13') INSERT INTO #T(D) VALUES ('04/01/2013 15:02'),('21/Dec/12 2:17 PM') SELECT D as 'Input value', CAST(D AS DATETIME) AS 'Output' FROM #TResults:Input value Output01/12/2012 2012-01-12 00:00:00.00003/Dec/2012 2012-12-03 00:00:00.00001/01/13 2013-01-01 00:00:00.00004/01/2013 15:02 2013-04-01 15:02:00.00021/Dec/12 2:17 PM 2012-12-21 14:17:00.000[/code] I hope this assists you. If NOT please post why not and maybe someone can assist you further.Thu, 21 Feb 2013 13:05:46 GMTbitbucket-25253http://www.sqlservercentral.com/Forums/Topic1422494-1292-1.aspxIf you want to include the time with the date use the DATETIME function in the CAST instead of DATE.Also What is suggested is not to just convert the three dates used in the example but that you populate a temporary table and use that as input to cast datetime formats of the input to the common format you want.Thu, 21 Feb 2013 12:45:50 GMTMiles Nealehttp://www.sqlservercentral.com/Forums/Topic1422494-1292-1.aspxThanks all for your help unitl so far.So, I tried your solution David but it didn't work. Or I didn't make it work I don't know :hehe:This is a sample of the data in the source 04/01/2013 15:0204/01/2013 15:4221/Dec/12 2:17 PM02/01/2013 14:3021/Dec/12 1:04 PM04/01/2013 13:4621/Dec/12 5:46 PMI don't know how to convert the hour, so still with a derived column, I just kept the date. Now I'm trying to convert it as dd/mm/yyyy...@bitbucket-25253I have a lot of datas, not juste 3, and I have to do an automatic task, so I don't think your solution is fine for this problem. But thank you :)By the way, sorry for my poor english :)Thu, 21 Feb 2013 12:24:11 GMTkanoe82http://www.sqlservercentral.com/Forums/Topic1422494-1292-1.aspxIf you import the data into a staging table, you could then execute: [code="sql"] DECLARE @D1 VARCHAR(20) DECLARE @D2 VARCHAR(20) DECLARE @D3 VARCHAR(20) SET @D1 = '01/12/2012' SET @D2 = '03/Dec/2012' SET @D3 = '01/01/13' SELECT CAST(@D1 AS DATE) AS 'was (dd/mm/yyyy)',CAST(@D2 AS DATE) AS 'was (dd/mmm/yyyy)' ,CAST(@D3 AS DATE) AS 'was (dd/mm/yy'Result:was (dd/mm/yyyy) was (dd/mmm/yyyy) was (dd/mm/yy)2012-01-12 2012-12-03 2013-01-01[/code]Thu, 21 Feb 2013 11:07:20 GMTbitbucket-25253http://www.sqlservercentral.com/Forums/Topic1422494-1292-1.aspxKanoe - did you get this working yet?Thu, 21 Feb 2013 10:22:44 GMTMiles Nealehttp://www.sqlservercentral.com/Forums/Topic1422494-1292-1.aspxIf all the input dates are valid dates in the format DMY then use a derived column as you stated but cast the input to date (proving your output table is expecting this)Try something like(DT_DBDATE)[Column 0]in the expression for the derived columnThu, 21 Feb 2013 07:40:08 GMTDavid Burrowshttp://www.sqlservercentral.com/Forums/Topic1422494-1292-1.aspxHello everyone,So I really am a newbie and I have a flat source ( csv file ) with some dates. But all the dates don't have the same formats. For exemple :01/12/2012 (dd/mm/yyyy)03/Dec/2012 (dd/mmm/yyyy)01/01/13 (dd/mm/yy)I have to convert the dates to the same format ( dd-mm-yyyy) with SSIS but I really don't know how. I used a derived colum to change mmm into mm with a replace function. but I don't know if it's a good solution to my problem. Any ideas please ?Thank you for your time anyway :)Thu, 21 Feb 2013 04:13:44 GMTkanoe82