title: How to cast Date with Time Zone into DateTime SQL Server
body: <p>i'm trying to cast a datetime with Time Zone, the original date is like:
  07/06/2015 08:35:02 AM PDT</p>
  
  <p>So i want to have the MAX date of the column (UserAddDate), </p>
  
  <p>i'm using this formula in SQL Server:</p>
  
  <p>MAX(CAST(LEFT(SIG.UserAddDate, 10) AS nvarchar)) </p>
  
  <p>and it works, i got this:
  02/18/2016, but i don't want to cast this into nvarchar, i want to cast it into DATETIME,
  And when I try to cast it, i got this error:
  Conversion failed when converting date and/or time from character string.</p>
  
  <p>Anyone knows why? , Thank you.</p>