Date: Date type in csv is uploaded as integer in R

Question

I had uploaded a csv containing a date column. When i did read.csv() in R and checked the typeof all columns, it displays all columns as integer type. I was able to convert character types successfully by using :

as.character(mydata$col3)

When trying the similar for date (values as- 17-JAN-95) as:

as.date(mydata$col5,"%Y%M%D")

The values returned are: please suggest the correct approach for modifying the datatype.

try `as.Date('17-JAN-95',"%d-%b-%y")` (or `%B` instead of `%b`, both should work) — Jaap, Sep 13 '16 at 08:01
When you ask a question it is always better to include a [reproducible example](http://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example). — Jaap, Sep 13 '16 at 08:07

Sandipan Dey · Accepted Answer · 2016-09-13T08:24:24.330

0

Try this

strptime(mydata$col5, '%d-%b-%y')

edited Sep 13 '16 at 08:24

answered Sep 13 '16 at 08:04

Sandipan Dey

21,482
2
51
63

Date: Date type in csv is uploaded as integer in R

1 Answers1