RE: AW: Daylight Saving Time

Can't you use UTCDIFF to work out the difference between UTC and your local
time, then add/subtract the difference to your GPS timestamp?
http://www.mysql.com/search/?q=UTC&charset=iso-8859-1&doc=2

-----Original Message-----
From: dksons@xxxxxxxxxxx [mailto:dksons@xxxxxxxxxxx]On Behalf Of Dusan
Kolesar
Sent: 19 November 2004 10:22
To: Zabach, Elke
Cc: SAP DB mailing list
Subject: Re: AW: Daylight Saving Time


>> Hello,
>> I have a proglem convert UTC into real timestamp.
>> There is some constant difference depending on time zone (+1 hour in my
>> time zone),
>> but there is Daylight Saving Time bias (+1 hour in DST interval).
>> In Europa
>>    DST starts : last Sunday in March at 1:00 UTC
>>    DST stops  : last Sunday in October at 1:00 UTC.
>> Is something implemented in the SapDb which helps me detect
>> if the Timestamp is in Daylight saving zone or not?
>>
>> Thank you for all your support.
>>
> TIMESTAMP is according to your kitchenclock -> inclusive local time and  > DST
> There is no function or the like available telling you 'we have DST  
> interval'
> But with SQLMODE Oracle the function NEXT_DAY may help
> WHERE the_date_to_be_check
>     BETWEEN NEXT_DAY ('24-MAR-04', 'Sun') AND NEXT_DAY ('24-OCT-04',  
> 'Sun')
>
> Elke
> SAP Labs Berlin
>

Thanks, but this didn't help me.
I'm using SQLMODE Internal and I don't plan to change it.
My problem is, that my client program inserts into my table
values directly from GPS device and this data includes UTC time.
So I need to correct it into normal (kitchenclock) time.

Even thought thank you for your response.

Dusan Kolesar


-=x=-
Skontrolované antivírovým programom NOD32


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:
http://lists.mysql.com/maxdb?unsub=david.radcliffe@xxxxxxxxxxxx


=======================================================
This message is intended solely for the use of the individual or organisation 
to whom it is addressed.  It may contain privileged or confidential 
information.  If you have received this message in error, please notify the 
originator immediately.  If you are not the intended recipient, you should not 
use, copy, alter, or disclose the contents of this message.  All information or 
opinions expressed in this message and/or any attachments are those of the 
author and are not necessarily those of VarTecTelecom Europe Ltd or its 
affiliates. VarTec Telecom Europe Ltd accepts no responsibility for loss or 
damage arising from its use, including damage from virus. 
=======================================================


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx