Skip to content
This repository has been archived by the owner on Dec 11, 2022. It is now read-only.

UTC conversion is returning offset data #307

Closed
tanner-bruce opened this issue Jan 21, 2021 · 2 comments
Closed

UTC conversion is returning offset data #307

tanner-bruce opened this issue Jan 21, 2021 · 2 comments

Comments

@tanner-bruce
Copy link
Contributor

Bug Report

Expected Behavior

Conversion to UTC should be performed seamlessly without needing to use a time shift.

Actual Behavior

When using the Convert to UTC option for querying a table based on UTC time with a TIMESTAMP type, the created Date object returns a time that is offset to UTC but still reported as the browser timezone, leading to the returned data being offset by the browser timezone.

Steps to Reproduce the Problem

  1. Create use a TIMESTAMP type time column
  2. Fill with UTC based data
  3. Have the browser timezone be something other than UTC
  4. Check the Convert to UTC option
@ofir5300
Copy link
Collaborator

Hi @tanner-bruce,
I couldn't reproduce the issue -
My browser indeed isn't set to UTC time, and when I used the convert to UTC option it worked well and convert my given time to a valid UTC time.

It might be related to your plugin version, please be sure you are up to date with our most recent version (currently 2.0.1 and soon to release another one).
Beside of that, if the issue still occur, please elaborate and be more specific so I will be able to reproduce it.

@ofir5300
Copy link
Collaborator

ofir5300 commented Mar 25, 2021

@tanner-bruce please feel free to create another issue with additional details if the problem still occur.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants