i never understand why people use datetime anyway.. unix timestamp is so
much easier to work with.
[EMAIL PROTECTED] wrote:
Hi,
just see the client connection timezone here :
http://dev.mysql.com/tech-resources/articles/4.1/time.html
you should certainly use --default-time-zone='-3:00'
Mathias
Selon Simon Garner <[EMAIL PROTECTED]>:
On 21/06/2005 2:45 p.m., Scott Haneda wrote:
I need to run a BETWEEN select where I put in a date rate, the time was at
one point irrelevant, but now the client is in a new time zone +3 hours
ahead, so
BETWEEN 20050101000000 AND 20051201235959 is what I pass in now, which is
wrong, how can I add three hours to it and get the days and months to wrap
as needed.
I would love to do this in SQL, not in application.
Try something like:
SELECT
*
FROM
table
WHERE
datefield > '2005-01-01 00:00:00'
AND datefield < DATE_ADD('2005-01-01 00:00:00', INTERVAL 3 HOUR)
http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html
-Simon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
