date and time conversion

An embedded and charset-unspecified text was scrubbed...
Name: not available
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20120502/fd8081d9/attachment.pl>
Quick and dirty solution is to use sub() to change the T to a space
and then use as.POSIXct as usual.

x <- "1981-01-02T08:00"

as.POSIXct(sub("T"," ", x), format = "%Y-%m-%d %H:%M")

but it does look to me like R can work around the T if you give a good
format argument:

as.POSIXct(x, format = "%Y-%m-%dT%H:%M")

Michael

Hi

I've been trying to convert numbers from an online temperature database
into dates and time that R recognizes. the problem is that the database has put a T
between the numbers and R will not accept any conversions.

this is the format that it's in now
1981-01-02T08:00

can anyone help?
cheers!

--
View this message in context: http://r.789695.n4.nabble.com/date-and-time-conversion-tp4602786.html
Sent from the R help mailing list archive at Nabble.com.
? ? ? ?[[alternative HTML version deleted]]

______________________________________________
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.
Hello,

mpostje wrote
Hi

I've been trying to convert numbers from an online temperature database
into dates and time that R recognizes. the problem is that the database
has put a T
between the numbers and R will not accept any conversions. 

this is the format that it's in now
1981-01-02T08:00

can anyone help?
cheers!

Try

x <- "1981-01-02T08:00"
x.new <- sub("T", " ", x)
as.POSIXct(x.new)

Hope this helps,

Rui Barradas

--
View this message in context: http://r.789695.n4.nabble.com/date-and-time-conversion-tp4602786p4603288.html
Sent from the R help mailing list archive at Nabble.com.