db-migrate / db-migrate/pg

Datetime should be mapped to timesamp "with time zone" instead of "without time zone"

Open
#12 6 comments 0 reactions 0 assignees View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.