Re: AW: Daylight Saving Time

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 : dusankolesar@xxxxxx
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/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx