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_j...@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@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. ______________________________________________ R-help@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.