Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

issue with Time Field for mongoBI #50

Closed
krunalsabnis opened this issue Mar 13, 2019 · 1 comment
Closed

issue with Time Field for mongoBI #50

krunalsabnis opened this issue Mar 13, 2019 · 1 comment
Labels
enhancement New feature proposal
Milestone
v0.4.3

Comments

@krunalsabnis
Copy link
Contributor

While using mysql driver for mongoBI

Time fields are mapped correctly in "time" field. But when selected any of them this error is thorwn

Error: Error: scalar function 'convert_tz' is not supported
@paveltiunov paveltiunov added the enhancement New feature proposal label Mar 13, 2019
@paveltiunov
Copy link
Member

@krunalsabnis Yep. Seems like Mongo BI connector lacks support of convert_tz function: https://docs.mongodb.com/bi-connector/master/supported-operations/ . We'd need to find a way to generate appropriate SQL for specific timezone.

paveltiunov added a commit that referenced this issue Mar 15, 2019
@paveltiunov
fix(mongobi-driver): implement convert_tz as a simple hour shift
c97e451 
Fixes issue #50
@paveltiunov paveltiunov added this to the v0.4.3 milestone Mar 15, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature proposal
Projects
None yet
Milestone
v0.4.3
Development

No branches or pull requests
2 participants
@paveltiunov @krunalsabnis