[prev in list] [next in list] [prev in thread] [next in thread] 

List:       r-sig-db
Subject:    Re: [R-sig-DB] RPostgreSQL driver timestamp data type mapping
From:       "Sebastian P. Luque" <spluque () gmail ! com>
Date:       2010-01-13 11:47:03
Message-ID: 87r5pumdl4.fsf () kolob ! sebmags ! homelinux ! org
[Download RAW message or body]

On Wed, 13 Jan 2010 07:09:57 +0000 (GMT),
Prof Brian Ripley <ripley-+7o2aNKnwVPQzY9nttDBhA@public.gmane.org> wrote:

[...]

> Not really: POSIXct times are absolute times: it is when they are
> displayed that you see the locale.  So just add a tzone attribute to
> the result, as in

> > x <- Sys.time()
> > x
> [1] "2010-01-13 07:07:26 GMT"
> > attr(x, "tzone") <- "PST8DST"
> > x
> [1] "2010-01-12 23:07:26 PST"
> > attr(x, "tzone") <- NULL
> > x
> [1] "2010-01-13 07:07:26 GMT"

Does setting tzone=NULL have the same effect as setting it to "GMT", in
that daylight savings are no longer relevant?  This is the only reason I
wanted to set it "GMT", and avoid daylight savings issues that I don't
need to deal with.  Usually I do this starting from a character vector,
as in:

as.POSIXct(strptime("2010-01-13 01:00:00", "%Y-%m-%d %H:%M:%S), tz="GMT")

Thanks,

-- 
Seb

_______________________________________________
R-sig-DB mailing list -- R Special Interest Group
R-sig-DB@stat.math.ethz.ch
https://stat.ethz.ch/mailman/listinfo/r-sig-db
[prev in list] [next in list] [prev in thread] [next in thread]