R - Numeric(int) to Date conversion

Question

I have a date.frame and a column with

values(20180213190133, 20180213190136, 20180213190173 , 20180213190193 , 20180213190213, 20180213190233, 20180213190333, 20180213190533, 20180213190733, 20180213190833, 20180213190833, 20180213190833, 201802131901833, 20180213191133, 20180213192133, 20180213194133, 20180213199133, 20180213199133, 20180213199133, 20180213199133, 20180213190136.... 1200 entries)

I want to convert this column which is of type int to Date.

I tried using : as.Date() and as.POSIXct(). Both doesn't work. I am getting N/A value.

Please let me how can I convert this filed from int to Date.

Thanks

Because it's a integer. You have to convert it first to `character` and then to `Date`. — patL, Mar 15 '18 at 15:19
Thanks patL, I did convert it to character. But i still get NA. `df <- as.Date.character(vp$ts , format = '%y%m%d%H%M')` — Mirza Hashim, Mar 15 '18 at 15:23
Try something like `as.POSIXct(values, origin = "1900-01-01")`, but with a different `origin`. — Rui Barradas, Mar 15 '18 at 17:52

Terru_theTerror · Accepted Answer · 2018-03-19T08:26:27.307

0

Try this:

Input data

values<-c(20180213190133, 20180213190136, 20180213190173)

values_date<-as.Date(substr(as.character(values),start = 1,stop=8), format = "%Y%m%d")
> values_date
[1] "2018-02-13" "2018-02-13" "2018-02-13"
> class(values_date)
[1] "Date"

If you want to mantain also hour/minute/second you can try this:

values_date<-as.POSIXlt(as.character(values), format = "%Y%m%d%H%M%S")

After this the class will be "POSIXlt" "POSIXt" and not Date but there are some strange info in your input data

In the third number, last two figures are "73", this number is incorrect for seconds and you will have NA in output.

values_date
[1] "2018-02-13 19:01:33 CET" "2018-02-13 19:01:36 CET" NA

edited Mar 19 '18 at 08:26

answered Mar 15 '18 at 15:39

Terru_theTerror

4,918
2
20
39

Thanks Terru, But i get date values as below, `> values_date [1] "1977-05-27" "1977-05-27" "1977-05-27"` i want the output to be: `[1] "2018-02-27" "2018-02-27" "2018-02-27"` – Mirza Hashim Mar 15 '18 at 17:02
Answer changed according to this problem. – Terru_theTerror Mar 16 '18 at 08:09
Hey Terru, It's working but partially. I do not get time. And when i put format as "%y%m%d%H%M%S", i get NA – Mirza Hashim Mar 19 '18 at 07:50
Answer changed according to this point. – Terru_theTerror Mar 19 '18 at 08:27
1

Hey, Thanks - it worked. Also,I added **'tz'** in my code and this works too. And yes, my input is incorrect, i just randomly typed some number. `values1 <- as.POSIXct(values,"%Y%m%d%H%M%S", tz = "UTC")` – Mirza Hashim Mar 20 '18 at 10:55
You are welcome! – Terru_theTerror Mar 20 '18 at 10:57

R - Numeric(int) to Date conversion

1 Answers1