AW: Daylight Saving Time

dksons@xxxxxxxxxxx 

> 
> 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

> --
> 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=elke.zabach@xxxxxxx

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