R help - May 2012 - date and time conversion

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]]

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

On Wed, May 2, 2012 at 6:10 AM, mpostje <mayo_jojo at hotmail.com>
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!
>
> --
> 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.