[R] Datetime conversion

[premmad]

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

-- 
View this message in context: http://www.nabble.com/Datetime-conversion-tp25503138p25503907.html
Sent from the R help mailing list archive at Nabble.com.