The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
I'm trying to figure out how to handle DST in my RSS feeds and keep confusing myself. If it started and ended on specific dates every year then it would be a simple matter of just checking what the date is and appending the appropriate time zone (GMT or +0100 in my case) but, because the dates are different every year, I just can't figure out an effective way of handling it. Any suggestions?
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Search is your friend
“I was having a mildly paranoid day, mostly due to thefact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Postet den
just leave them as GMT and tell everyone that they are GMT 
Doesn't your RSS get it's time from the server which should update itself automatically anyway.
Doesn't your RSS get it's time from the server which should update itself automatically anyway.
Postet den
Yeah, I was perfectly happy to leave them as GMT but a site in America that's pulling in one of my feeds converts the timestamps to their own local time so anything with a GMT timezone that's actually DST is being converted to an hour in the future and they're not displaying it. Looking ahead, I can see this being a problem on a site I've got lined up for next month which is expected to have a large international audience.
The date and time is being pulled from my database - where it's stored the same way we store dates here (yyyymmddhhmmss) - and then being converted to a valid date/time string so I've no way of telling if the time for each record in the database is GMT or DST.
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
The date and time is being pulled from my database - where it's stored the same way we store dates here (yyyymmddhhmmss) - and then being converted to a valid date/time string so I've no way of telling if the time for each record in the database is GMT or DST.
Search is your friend
“I was having a mildly paranoid day, mostly due to thefact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Postet den
You might use something like that:
Code:
Function RSSTime(strTime)
od = strToDate(strTime)
set oShell = CreateObject("WScript.Shell")
atb = "HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\TimeZoneInformation\ActiveTimeBias"
offsetMin = oShell.RegRead(atb)
RSSTime = dateadd("n", offsetMin, od)
End Function
Postet den
Originally posted by Shaggy1) a GMT time can not be a DST time, it is not possible
Yeah, I was perfectly happy to leave them as GMT but a site in America that's pulling in one of my feeds converts the timestamps to their own local time so anything with a GMT timezone that's actually DST is being converted to an hour in the future and they're not displaying it. Looking ahead, I can see this being a problem on a site I've got lined up for next month which is expected to have a large international audience.
The date and time is being pulled from my database - where it's stored the same way we store dates here (yyyymmddhhmmss) - and then being converted to a valid date/time string so I've no way of telling if the time for each record in the database is GMT or DST.
2) The forum stores time based on the server +/- whatever you have set in your forum admin, and the servers time will be gmt or dst depending where it is, and will update itself automatically.
3) the problem is infact with them, your RSS is updating itself and displaying times in DST as it should, it is their code that has buggered it up since it does not know that the clocks have changed not you.
Postet den
Originally posted by HuwR 1) a GMT time can not be a DST time, it is not possibleThat's the problem. At the moment, all the times in my feed have GMT appended to them which is fine for anything posted last week but anything posted this week should have +0100 instead of GMT as the timezone because, as you say, DST is not GMT. The times are inserted into the database based on the current server time (GMT last week, DST this week) so the problem is arising when I pull them and just throw GMT on the end; this site checks the timezone in the timestamp and adjusts it accordingly to display it in their local time.
For example:
If I posted an article at 17:51 last Friday, it would be stored in the database as 20090327175100 and, when I then pulled it from the database and ran it through the function below, it would correctly display as Fri, 27 Mar 2009 17:51:00 GMT.
If I made a post at the exact same time today (now), it would also be stored as 20090330175100 so, when I pull it from the database and run it through the same function, it would be displayed incorrectly as Mon, 30 Mar 2009 17:51:00 GMT which is an hour into the future. It should display as either Mon, 30 Mar 2009 17:51:00 +0100 or Mon, 30 Mar 2009 16:51:00 GMT
Here's the function I run the string through:
Code:
function timestamp(str)
if isnull(str) or len(str)=0 then exit function
timestamp=mid(str,7,2)&"/"&mid(str,5,2)&"/"&left(str,4)
if isdate(timestamp) then
timestamp=cdate(timestamp)
timestamp=weekdayname(weekday(timestamp),true)&", "&day(timestamp)&" "&monthname(month(timestamp),true)&" "&year(timestamp)&" "&mid(str,9,2)&":"&mid(str,11,2)&":"&right(str,2)&" GMT"
else
timestamp=""
end if
end functionfact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”