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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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/[EMAIL PROTECTED] ======================================================= 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/[EMAIL PROTECTED]
