StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
14064892
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-12-28T05:13:40.847
FavoriteCount
0
LastActivityDate
2012-12-28T05:13:40.847
LastEditDate
LastEditorUserId
0
OwnerUserId
168868
ParentId
14058283
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
The main problem is that MySQL's support for timezones is laughable. Most other databases let you define the timezone as part of the datetime column, but not MySQL. Instead, they force you to do a connection-wide or server-wide timezone setting. Your best bet is making sure MySQL stores all datetimes as GMT / UTC. You can enforce this by running <code>SET time_zone = 'UTC'</code> on connect. Do it at the same time as you set the character set. You are setting the connection character set, right? PHP-side, you can then use a combination of <a href="http://php.net/class.datetime" rel="nofollow">DateTime</a> and <a href="http://php.net/class.datetimezone" rel="nofollow">DateTimeZone</a> to take the datetimes from MySQL and display them in the user's timezone. For example, let's pretend that we get the date <code>2012-11-13 14:15:16</code> from a MySQL <code>DATETIME</code> column. From the PHP interactive prompt: <pre><code>php > $from_mysql = '2012-11-13 14:15:16'; php > $utc = new DateTimeZone('UTC'); php > $ts = new DateTime($from_mysql, $utc); php > $pdt = new DateTimeZone('America/Los_Angeles'); php > $ts_pdt = clone $ts; php > $ts_pdt->setTimezone($pdt); php > echo $ts_pdt->format('r'), "\n"; Tue, 13 Nov 2012 06:15:16 -0800 </code></pre> As demonstrated, you just need to create the DateTime by expressly telling it you're UTC, if UTC isn't the timezone you've set using <code>date_default_timezone_set</code>. Switching the timezone of a DateTime is as easy as giving it a new one. I've used <code>clone</code> here to work on a copy. DateTimes are mutable, and it's sometimes easy to find yourself accidentally clobbering it. Reverse date math works the same way, just transform their selection into UTC and run the math on the native numbers. tl;dr: <ul> <li>Store and perform calculations on datetimes in UTC (GMT) only</li> <li>Display all datetimes in the user's timezone only</li> </ul>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POChanging time zones and getting results from MYSQL based on that
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USCharles
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.