[ale] MySQL DATETIME

Chris Fowler cfowler at outpostsentinel.com
Mon Jun 2 16:16:58 EDT 2014


On 05/30/2014 09:23 PM, Alex Carver wrote:
> 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.

This would be the best way.  I can then run queries via the mysql client 
using the TZ environment variable.

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?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ale.org/pipermail/ale/attachments/20140602/072c830b/attachment.html>


More information about the Ale mailing list