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]
