Thank you David, my problem is solved now.
Very easy solution.
Dusan
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
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
--
Dusan Kolesar
Helsinska 19
040 13 Kosice
Slovakia
e-mail : [EMAIL PROTECTED]
ICQ# : 160507424
-=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]
