<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 05/30/2014 09:23 PM, Alex Carver
wrote:<br>
</div>
<blockquote cite="mid:53892F18.2090704@acarver.net" type="cite">
<pre wrap="">This depends on how the "started" field is declared. If it's a
TIMESTAMP then MySQL autoconverts any input to UTC as it stores to disk
and then feeds it back out according to the local TZ. A DATETIME field
does not perform an autoconversion.
</pre>
</blockquote>
<br>
<font size="-1">This would be the best way. I can then run queries
via the mysql client using the TZ environment variable.<br>
<br>
Do you know if it is possible, and how, I can do an alter table to
convert the datetime column to a type of timestamp?<br>
</font>
</body>
</html>