Timezone is being added to time from mysql DB

Question

I am using angularjs on the frontend and a mysql DB. I am using ui.bootstrap timepicker to select a time. The issue that I am having is that the user will pick a time and it will look like this: Thu Apr 27 2017 09:00:00 GMT-0600 (Mountain Daylight Time).

The time is saved just fine to the DB looking like this: 2017-04-27 09:00:00.000. When the date gets retrieved from the DB it is then changed to look like this: Thu Apr 27 2017 15:00:00 GMT-0600 (Mountain Daylight Time).

I can see what is going on; it is adding the timezone to the date. What I don't understand is why it is doing this and how to fix it, so it shows the time that the user put in.

Please help and give direction.

score 0 · Answer 1 · answered Apr 27 '17 at 04:00

0

Just convert all the time to utc before saving to db. And while retrieving the time you should convert it to your desired timezone.

This will help you to get the correct result.

answered Apr 27 '17 at 04:00

Nair Athul

823
9
21

I have looked for examples of this yet have not been able to find any. Will you include one in your answer? – maus Apr 27 '17 at 18:34
Sure let me check – Nair Athul Apr 28 '17 at 03:30
Please go through this SO link - http://stackoverflow.com/questions/20662140/using-angularjs-date-filter-with-utc-date – Nair Athul Apr 28 '17 at 03:36

Timezone is being added to time from mysql DB

1 Answers1