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.
