SQL Server Performance Forum – Threads Archive
problem with Day light saving
I got a problem here for the Oracle SQL, <br />one of my quries that :<br />Select <br /> enddate, <br /> enddate-durationtime as starttime —> this may cause problem, because<br /> — this starttime may start at the Day light saving time in USA. exp : 2:39 am on April 3<br /> — <br />From <br /> TableA<br /><br />Here is one query to fix this problem<br />–check to see if the starttime in 1st sunday in April 2-3am?<br />Case when To_Char(enddate-durationtime , ‘MM’) = 04 And To_Char(enddate-durationtime , ‘W’) = 1 And To_Char(enddate-durationtime , ‘D’) = 1 And To_Char(enddate-c.durationtime , ‘HH24:MI<img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />S’) > ’02:00:00′ And To_Char(enddate-durationtime , ‘HH24:MI<img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />S’) < ’03:00:00′ Then enddate-durationtime -1/24 Else enddate-durationtime End as starttime<br /><br />This query may slow down the system, and this day light saving only happens once a year, which may be not worthy, and also this query only fix problem in USA, so I wonder any ohter better way to fix this , <br /><br /><br />Thanks<br /><br /><br /><br /><br /><br /><br />Check this you may find some information [urhttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=28712[/URL]
You also might want to check out the Oracle category at<a target="_blank" href=http://www.dbforums.com.>http://www.dbforums.com.</a> <a target="_blank" href=http://www.lazydba.com>http://www.lazydba.com</a> also has a great subscription forum for Oracle questions. Be careful if you subscribe to the emails though. [<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />] You WILL need a filter to put them automatically in a folder. It’s an extremely active forum for Oracle. Great way to build a script library though.<br /><br />MeanOldDBA<br />[email protected]<br /><br />When life gives you a lemon, fire the DBA.
]]>