Seems to work alright for me. datetime <-c( "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")
> date<-strptime(datetime,"%d%b%Y") > date [1] "1987-10-01" "2004-04-12" "1987-12-01" "1975-10-01" "1979-08-01" "2003-06-26" [7] "1900-01-01" "1998-05-13" "1998-09-30" cheers, -Girish premmad wrote: > > 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 test file and i have imported it in to R and created dataframe > test with variable datetime for extracting only the datepart from it. > By using the following function > > 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-tp25503138p25505915.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.