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