title: node.js mysql - Extract datetime in YYYY-MM-DDThh:mm:ssZ format without milliseconds
body: <p>I'm importing datetime information in this format:</p>
  <pre><code>2020-04-17T19:08:28Z
  </code></pre>
  <p>into a mysql datetime column.</p>
  <p>When I make a select I get the data in this format back:</p>
  <pre><code>2020-04-17T19:08:28.000Z
  </code></pre>
  <p>What I would like is the original format though. How to do so exactly? So goal:</p>
  <pre><code>2020-04-17T19:08:28Z
  </code></pre>
  <p>That's my setup:</p>
  <pre><code>var connection = mysql.createConnection({
    host     : 'host',
    user     : 'u',
    password : 'p',
    database : 'db'
  });
  
  connection.query(&quot;Select * FROM table&quot;, function(err, rows) {
      if (err) {
        console.log(err);
      } else {
        console.log(rows)
      }
  });
  </code></pre>
  <p>rows:</p>
  <pre><code>[ [ {
        column_date: 2020-04-17T19:08:28.000Z,
        ...
      ... 1846 more items ] ]
  </code></pre>
  <p><a href="https://github.com/mysqljs/mysql#connection-options" rel="nofollow noreferrer">https://github.com/mysqljs/mysql#connection-options</a></p>