How to extract only date given timezone (date 2017-06-21T18:00:00.000Z) in javascript?

Question

MySQL

I am using node.js. Mysql returns value in UTC, how to configure mysql to take into account the time zone? or do these transformations with javascript?

Answer 1

Let the server consider UTC. at the front take an indent and do whatever var offset = (new Date).getTimezoneOffset()/60 this is in hours

Answer 2

MySQL Timezone Cheatsheet