The utc-time tag has no wiki summary.
2
votes
1answer
65 views
WorldWide site - should I save UTC or in fixed time?
Let's say I have a world wide website ( I mean it has uses from all around the world).
I have 1 server which is in germany ( at some city). it will never be moved from germany - ever.
My question ...
3
votes
3answers
1k views
How can I get the correct offset between UTC and local times for a date that is before or after DST?
I currently use the following to get a local datetime from a UTC datetime:
SET @offset = DateDiff(minute, GetUTCDate(), GetDate())
SET @localDateTime = DateAdd(minute, @offset, @utcDateTime)
My ...
0
votes
2answers
3k views
MySQL Set UTC time as default timestamp
How do I set a timestamp column whose default value is the current UTC time?
MySQL uses UTC_TIMESTAMP() function for UTC timestamp:
mysql> SELECT UTC_TIMESTAMP();
+---------------------+
| ...
