title: Remove timezone completely from SQL Server
body: <blockquote>
    <p>EDIT: Some users noted that this is a duplicate of ADO.NET question at
    <a href="https://stackoverflow.com/questions/13725924/how-can-i-get-datetime-data-from-sql-server-ignoring-time-zone-issues">How can I get DateTime data from SQL Server ignoring time zone issues?</a></p>
    
    <p>Please DO READ my tags, and my codes. This is <strong>nodejs question</strong>,
    that has <strong>nothing to do with ADO library</strong> whatsoever. It doesn't
    even run on Windows. The option noted at the link provided doesn't even exists at mssql-npm</p>
  </blockquote>
  
  <p>I am creating a database for company attendance, which spans for 3 timezones. </p>
  
  <p>The problem with SQL Server is that I read the working hour differently from each timezone. It registered like <code>1969-12-31T23:00:00.000Z</code>, and registers as 06:00 for one timeline, and 08:00 for another. I need it to be exactly at 08:00 regardless of timezone. It means, 08:00 at western part of my country, and also 08:00 at eastern part of my country. </p>
  
  <p>When I try to disable UseUTC, nodejs translated my timezone twice. For example, this is when I sent <strong><code>masuk</code></strong> field as 08:00</p>
  
  <hr>
  
  <p><strong>Sent to server:</strong></p>
  
  <p><a href="https://i.stack.imgur.com/60Z5x.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/60Z5x.png" alt="Sent to server"></a></p>
  
  <hr>
  
  <p><strong>Query sent to SQL Server:</strong></p>
  
  <p><code>UPDATE shift SET name = 'Shift 1', masuk = '2019-10-28T01:00:00.000Z', keluar = '2019-10-28T10:00:00.000Z', tolerance = 15 WHERE id = 1</code></p>
  
  <hr>
  
  <p><strong>Received the result back</strong></p>
  
  <p><a href="https://i.stack.imgur.com/apy5n.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/apy5n.png" alt="result"></a></p>
  
  <hr>
  
  <p><strong>And shown to the user as:</strong></p>
  
  <p><a href="https://i.stack.imgur.com/1xM9B.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1xM9B.png" alt="Show to user"></a></p>
  
  <p>My country sits at GMT+7 to GMT+9. I don't mind if I have to flatten the timezone. But how to do that? Is there a way to read the time completely ignoring the time zone? It makes my work unnecesarily complicated. </p>
  
  <p>I am using:</p>
  
  <ul>
  <li>SQL Server 2012</li>
  <li>Material UI</li>
  <li>date-fns</li>
  <li>Nodejs 12</li>
  <li>mssql module</li>
  </ul>
  
  <p>and this is my code to get the time from user input</p>
  
  <pre><code>&lt;MuiPickersUtilsProvider utils={DateFnsUtils}&gt;
      &lt;KeyboardTimePicker
          key={component.field.toString()}
          variant="inline"
          value={value}
          label={component.title}
          onChange={this.eventHandler(component.field).bind(this)}
          format="HH:mm"
      /&gt;
  &lt;/MuiPickersUtilsProvider&gt;
  </code></pre>
  
  <p>Thank you for help. </p>
  
  <p>THe database uses <code>time(7)</code> to store the time</p>