Thanks for your reply datetime 01OCT1987:00:00:00.000 12APR2004:00:00:00.000 01DEC1987:00:00:00.000 01OCT1975:00:00:00.000 01AUG1979:00:00:00.000 26JUN2003:00:00:00.000 01JAN1900:00:00:00.000 13MAY1998:00:00:00.000 30SEP1998:00:00:00.000
is in the file and i have imported it in to R and created dataframe test with variable datetime for extracting only the datepart from it. test$date<-strptime(test$datetime,"%d%b%Y") and i got the following error Error in `$<-.data.frame`(`*tmp*`, "rw", value = list(sec = c(0, 0, 0, : replacement has 9 rows, data has 14 Is there any other way to solve this, please do reply . David Winsemius wrote: > > > On Sep 18, 2009, at 1:03 AM, premmad wrote: > >> >> I'm relatively new to R .I tried converting the datetime column with >> values >> like 01apr1985:00:00:00.000 using strptime(datetime,"%d%b%Y).Could >> anyone >> help me in this regard .Please reply ASAP i need . > > You will need to give us a more complete sample of your code, because > I don't see a problem: > > > strptime("01apr1985:00:00:00.000","%d%b%Y") > [1] "1985-04-01" > > also works when hours, minutes and seconds format was used: > >> > strptime("01apr1985:00:00:00.000","%d%b%Y:%H:%M:%S") >> [1] "1985-04-01" >> > strptime("01apr1985:00:00:00.000","%d%b%Y:%T") >> [1] "1985-04-01" >> > > David Winsemius, MD > Heritage Laboratories > West Hartford, CT > > ______________________________________________ > 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. > > -- View this message in context: http://www.nabble.com/Datetime-conversion-tp25503138p25503907.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ 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.