Hello, i have a table that contains datetime entries which are stored in GMT. Now I would like to convert these datetime values in a select statement to local time. I first thought of someting like this (in germany DST starts at 2004-03-29�02:00:00 and ends�"2004-10-31�03:00:00" this year. The difference from GMT to local time is 1h and from GMT to local DST time 2h):
SELECT�� ��if(datetime�between�"2004-03-29�02:00:00"�AND�"2004-10-31�03:00:00", ��������DATE_ADD(datetime,�INTERVAl�2�HOUR),���� ��������DATE_ADD(datetime,�INTERVAL�1�HOUR)���������������� �����)�FROM�table�...� ��... This basically works but of course only if the select statement return rows with datetime entries in the year 2004. Eg if there are rows with a datetime field of "2003-xx-xx" then the statement from above will fail. Is there any more general way to do such a timezone conversion or is the only solution to let the application to this work that reads the MYSQL output? Thanks Rainer -- --------------------------------------------------------------------------- Rainer Krienke, Universitaet Koblenz, Rechenzentrum, Raum A022 Universitaetsstrasse 1, 56070 Koblenz, Tel: +49 261287 -1312, Fax: -1001312 Mail: [EMAIL PROTECTED], Web: http://www.uni-koblenz.de/~krienke Get my public PGP key: http://www.uni-koblenz.de/~krienke/mypgp.html ---------------------------------------------------------------------------
pgp00000.pgp
Description: signature
