<snip>
>-----Original Message-----
>From: sono-io@stripped [mailto:sono-io@stripped]
>Sent: Monday, June 20, 2011 6:01 PM
>To: mysql@stripped>Cc: wharms@stripped; Jerry Schwartz
>Subject: Re: SELECT records less than 15 minutes old
>
>On Jun 20, 2011, at 10:11 AM, Jerry Schwartz wrote:
>
>>> You should use UTC time zone or you will run into trouble with DST.
>>>
>> [JS] If you do that, you can't use an automatic timestamp field. You have
>> to
>> set the field yourself.
>
> Thanks Walter and Jerry.
>
> Is there a way to get NOW() to use UTC instead of the server timezone?
>(The server is not mine, so I can't change the my.cnf.) Here's my statement:
>
>SELECT * FROM `log` WHERE `id` = $_id AND ( `time_stamp` >= DATE_SUB(NOW(),
>INTERVAL 30 MINUTE) )
>
> Earlier in my PHP script I've used date_default_timezone_set, but that
>doesn't affect the MySQL statement.
>
>------
>
>Possible Solution
>
>I tried: SET time_zone = 'UTC';
>but MySQL complained with: #1298 - Unknown or incorrect time zone: 'UTC'
>
>I then tried:
>SET time_zone = '-0:00';
>and that seems to have worked. Is this the correct way to do it?
>
[JS] I believe that is the only way to do it.
The reason you can't use time zone names is that the time zone tables in MySQL
have not been loaded.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
E-mail: jerry@stripped
Web site: www.the-infoshop.com

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.