title: Convert String to datetime in SQL Server 2008
body: <p>How will I convert date in the format <code>Sat Mar 29 00:00:00 EST 1975</code> to <code>datetime</code> in TSQL?</p>
  
  <p>I get the date in this format from an old table which defined the date of birth column as <code>NVARCHAR</code> and stores the data as <code>Mon Jun dd hh:mm:ss GMT yyyy</code> format. I need to read another table which has the dob in <code>datetime</code> using this value.</p>
  
  <p>So basically I want to convert, say <code>Sat Mar 29 00:00:00 EST 1975</code> to <code>1975-03-29 00:00:00.000</code></p>
  
  <p>Is there a way in T-SQL to do this conversion? I tried the <code>CONVERT</code> function, but I am unable to locate the correct 'style' to use.</p>