Re: [R] DateTime Math in R - POSIXct

From: Galen Moore <galen.a.moore_at_gmail.com>
Date: Mon, 30 May 2011 21:41:39 -0600


Thank you, David.

I am not subtracting the seconds to convert POSIXct's GMT to MDT, and don't understand why I should need to.

Any hints, however, as to why
dateP <- as.POSIXct(tstamp, origin="1970-01-01", tzone="MDT") returns a date in the correct tz in my first instance below, yet

dateP2 <- as.POSIXct(dateN, origin="1970-01-01", tzone="MDT") decides to revert to GMT in my second instance below?

Thanks,

Galen

-----Original Message-----
From: David Winsemius [mailto:dwinsemius_at_comcast.net] Sent: Monday, May 30, 2011 20:31
To: galen.a.moore_at_gmail.com
Cc: r-help_at_r-project.org
Subject: Re: [R] DateTime Math in R - POSIXct

On May 30, 2011, at 10:20 PM, Galen Moore wrote:

> Greetings -
>
>
>
> I'm battling POSIXct, as per the code below. My input is actually an
> XL file, but the weird results below correctly model what I am seeing
> in my program.
>
>
>
> Before I punt and use lubridate or timeDate, could anyone please help
> me understand why POSIXct forces my variable back to GMT?
>
>
>
> I suspect that I'm not properly coding the tzone value, but it does
> not throw an error as-is.
>
>
>
>
>
>> tstamp <- "2011-05-22 11:45:00 MDT"
>
>> mode(tstamp)
>
> [1] "character"
>
>>
>
>> dateP <- as.POSIXct(tstamp, origin="1970-01-01", tzone="MDT")
>
>> mode(dateP)
>
> [1] "numeric"
>
>> dateP
>
> [1] "2011-05-22 11:45:00 MDT"
>
>>
>
>> dateN <- as.numeric(dateP)
>
>> dateN
>
> [1] 1306086300
>

So now the internal representation is referenced to GMT

>>
>
>> dateP2 <- as.POSIXct(dateN, origin="1970-01-01", tzone="MDT")
>
>> dateP2

And you are telling the function to add as many hours offset as needed for the difference between GMT and MD T.....

--
David.

>
> [1] "2011-05-22 18:45:00 MDT"
>
David Winsemius, MD West Hartford, CT ______________________________________________ R-help_at_r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Received on Tue 31 May 2011 - 03:44:02 GMT

This quarter's messages: by month, or sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

All messages

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Tue 31 May 2011 - 07:40:11 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive