TIMESTAMP or DATETIME in MySQL

Asked Mar 04 '17 at 10:46

Active Mar 04 '17 at 10:46

Viewed 380 times

I am living in Germany, but want to test a website in the US. I will be using a MySQL database, where the current time will be saved and I heard that TIMESTAMP can take timezones into account, so I'm not sure whether to use TIMESTAMP or DATETIME in MySQL.

All of the entries will be created by people in the US and of course, every user should see the time in their current timezone.

Thanks in advance!

asked Mar 04 '17 at 10:46

sebjel

1

Possible duplicate of [Should I use field 'datetime' or 'timestamp'?](http://stackoverflow.com/questions/409286/should-i-use-field-datetime-or-timestamp) – Bart Friederichs Mar 04 '17 at 10:48
my two cents is to use datetime – Feralheart Mar 04 '17 at 11:34

TIMESTAMP or DATETIME in MySQL

0 Answers0