title: SQL Server Current_Timestamp Format
body: <p>I'm learning SQL Server and have an update statement where the current date and time are inserted as follows:</p>
  
  <pre><code>UPDATE data_table 
  SET Date_Time_Cx = CURRENT_TIMESTAMP
  </code></pre>
  
  <p>When it is populated in the DB, it appears <code>"Feb 22 2018 5:07PM"</code>. How do I get to populate with the format <code>"YYYY-MM-DD hh:mm:ss"</code>? I looked through the SQL Server documents and lots of posts and it seems like it should be populating in the desired way. Where did I go wrong? Thanks! </p>