Problems DST

On Wed, Dec 12, 2012 at 12:13 AM, Randy reed <randywreed at gmail.com> wrote: > Hi All, > > I wrote a xquery in Basex that created an xml file that calculated > student grades. Points are dependent on students doing an activity in > a window which ends at midnight on sunday each week. The date/time of > the activities are stored in the source file in UTC. However, to know > if they met the deadline, I need it in local time. I do this by > creating a function that translates epoch to a regulate dateTime > variable. But I see that when we left daylight savings time, things > were thrown off by an hour. The command I use is: > > adjust-dateTime-to-timezone((xs:dateTime("1970-01-01T00:00:00-00:00") > + xs:dayTimeDuration(concat("PT", $v, "S"))),xs:dayTimeDuration('-PT4H')) > > clearly the problem is the last part -PT4H, because dates that fall > after the switch back to standard time from daylight savings time > should be -PT5H. Is there a better way of doing this? Is there another > command that will give me a localized date that takes into account > daylight savings time issues? I tried to set a java calendar but I > could not make it work. > > Any help would be gratefully appreciated. > Thanks in advance > Randy > > -- > Dr. Randall Reed > Assistant Professor, Dept. of Philosophy and Religion > Appalachian State University > _______________________________________________ > BaseX-Talk mailing list > BaseX-Talk at mailman.uni-konstanz.de > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk

On Wed, Dec 12, 2012 at 1:13 AM, Randy reed <randywreed at gmail.com> wrote: > Hi Christian, > > Thanks for your response. I think that fn:implicit-timezone() would work for > current dates but I'm not sure if it would work for dates in the past since > it doesn't take any arguements. > > I need some way that it can take a date in utc and adjust to the current > timezone if its during that time period (i.e. we are currently in standard > time) or adjust it if it was in the past during daylight savings time. If > there was something that could read a utc date and then indicate whether it > was during the daylight savings time period or not I could make the time > adjustment. > > In java there is a inDaylightTime property but it requires a date and > timezone object. and it errors when I try to invoke it "invalid arguments" > when it tries to initialize the constructor.. > > declare namespace tz = "java:java.util.TimeZone"; > declare namespace dt = "java:java.util.Date"; > > let $fdate := dt:new(1347425558) > let $tmz := tz:getDefault() > let $day := tz:inDaylightTime($tmz, $fdate) > return $day > > Any help you could provide would be much appreciated. I am not a Java > programmer so I might not understand something here. > > Randy > > > On Dec 11, 2012 6:18 PM, "Christian Grün" <christian.gruen at gmail.com> wrote: >> >> Hi Randy, >> >> fn:implicit-timezone() may come in handy here. It returns your current >> local timezone: >> >> http://www.xqueryfunctions.com/xq/fn_implicit-timezone.html >> >> Best, >> Christian >> ___________________________ >> >> On Wed, Dec 12, 2012 at 12:13 AM, Randy reed <randywreed at gmail.com> wrote: >> > Hi All, >> > >> > I wrote a xquery in Basex that created an xml file that calculated >> > student grades. Points are dependent on students doing an activity in >> > a window which ends at midnight on sunday each week. The date/time of >> > the activities are stored in the source file in UTC. However, to know >> > if they met the deadline, I need it in local time. I do this by >> > creating a function that translates epoch to a regulate dateTime >> > variable. But I see that when we left daylight savings time, things >> > were thrown off by an hour. The command I use is: >> > >> > adjust-dateTime-to-timezone((xs:dateTime("1970-01-01T00:00:00-00:00") >> > + xs:dayTimeDuration(concat("PT", $v, >> > "S"))),xs:dayTimeDuration('-PT4H')) >> > >> > clearly the problem is the last part -PT4H, because dates that fall >> > after the switch back to standard time from daylight savings time >> > should be -PT5H. Is there a better way of doing this? Is there another >> > command that will give me a localized date that takes into account >> > daylight savings time issues? I tried to set a java calendar but I >> > could not make it work. >> > >> > Any help would be gratefully appreciated. >> > Thanks in advance >> > Randy >> > >> > -- >> > Dr. Randall Reed >> > Assistant Professor, Dept. of Philosophy and Religion >> > Appalachian State University >> > _______________________________________________ >> > BaseX-Talk mailing list >> > BaseX-Talk at mailman.uni-konstanz.de >> > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk