title: Convert and Cast Datetime not working
body: <p>I currently import a csv file into SQL via an SSIS package, on of the fields tIS date time. However the datetime field has GMT on the end (11/08/2013 15:47:53 GMT) so I do the below to remove it.</p>
  
  <p><code>CAST(REPLACE(Date, ' GMT', '') AS DATETIME) AS yDate</code> </p>
  
  <p>This give me the following format <code>2013-11-08 15:47:53.000</code> - which should be YYYY-MM-DD</p>
  
  <p>however I am having real problems converting the date into YYYY-DD-MM format, as SQL seems to think its the 11-Aug-2013 and not the 08-Nov-2013. I'm thinking its something to do with the replace code that removes the GMT but everything I try gives the same result?</p>
  
  <p>has anyone come across anything similar?</p>