Displaying 4 results from an estimated 4 matches for "posixxx".
2003 Aug 12
2
SQL Dates
How can I have SQL queries (ODBB/Windows) return dates (cf text) for date columns?
I can successfully query and ODBC database with R. I can subsequently convert the text representations of dates in columns using as.POSIXxx functions but I figured there must be a way to achieve this at the time of the query.
Any tips?
paul
2006 May 21
1
POSIX, time zone and Windows
...the 'tz' issue in POSIX objects. I have a
'simple' thing on which I must make up my mind but cannot do it from the
existing R-help threads. I am currently working on dog telemetry in
China, and download time information from GPS collars. I would like to
set up the corresponding POSIXxx variables in R to a given time zone. Eg
Pekin GMT+8:00.
I cannot find out how to do it properly. For instance:
mydate<-""06/05/16/11:30:00""
mydate<-strptime(mydate, "%y/%m/%d/%H:%M:%S")
mydate
[1] "2006-05-16 11:30:00"
as.POSIXct(mydate)
[1] "...
2006 Mar 07
4
POSIX time zone codes
The manual entry for as.POSIX says this about time zone codes...
Usage
as.POSIXct(x, tz = "")
tz
A timezone specification to be used for the conversion...
but it fails to mention what these "specifications" are. So far, I
have tried...
as.POSIX(x, tz="UTC") ... works, gives UTC times
as.POSIX(x, tz="UTC") ... works, gives EST times
as.POSIX(x,
2006 Mar 08
0
survival
...the trick. Any thoughts on where I
go go for a reference for these time codes? Where did you get
"CDT6CST" from? Or is this just one of those things that is "common
knowledge" in UNIX circles.
To the R developers: I recommend a sentence be added to the manual
for as.POSIXxx such as "vales for tz are system dependent, examples
for common systems are....."
Thanks!
On Mar 7, 2006, at 9:00 AM, Gabor Grothendieck wrote:
> Only "" and "GMT" are really guaranteed to work on all systems
> since the time zones are system dependent b...