See if this is what you are looking for: dt <- as.data.frame(datetime) > date<-strptime(as.character(dt$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: > > Girish it works for me also if its a vector.I have problem if the data is > stored as dataframe(rows and columns) please do help me in this > > Girish A.R. wrote: >> >> 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-tp25503138p25506234.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.