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=gcdm-maxdb@xxxxxxxxxxx