Datetime should be mapped to timesamp "with time zone" instead of "without time zone"
- Dominant language
- JavaScript
- Stars
- 68
- Forks
- 50
- PR merge metrics
- No merged PRs in 30d
Description
Hi, there is currently no way to create a column with the type `timestamp with time zone`.
When I look into the code I found that `datetime` is mapped to `timestamp`. So no matter if I define a `timestamp` or a `datetime` I will have a `timezone`.
In the [MySQL documentation for `DATETIME`](http://dev.mysql.com/doc/refman/5.7/en/datetime.html) you can see that this type of column takes care of local time zone.
Is there something wrong to map `datetime` to `timestamp with time zone` ?
I tried to update the mapping locally and all work fine for me. Do you see any issue doing this ?
If not I can submit a PR with these changes.
Thanks.
##
---
Want to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/38356793-datetime-should-be-mapped-to-timesamp-with-time-zone-instead-of-without-time-zone?utm_campaign=plugin&utm_content=tracker%2F14258523&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F14258523&utm_medium=issues&utm_source=github).
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.