Convert numbers to dates

Question

I have a table, one of the columns is dates in form at 20130109 or YearMonthDay with no spacing.

I'm trying to graph these points, and because of this odd spacing, end up with big gaps in the graph, and thus want to convert these numbers into dates.

I've been trying to use as.Date(as.character(20130107), "%y%m%d") but that always returns an NA.

Here's a good starter reference for date formatting: http://www.statmethods.net/input/dates.html — Señor O, Jan 09 '13 at 22:47

score 19 · Accepted Answer · answered Jan 09 '13 at 22:22

19

You need %Y (4 digit year) not %y (2 digit year):

> as.Date(as.character(20130107), "%Y%m%d")
[1] "07-01-2013"

answered Jan 09 '13 at 22:22

Joshua Ulrich

173,410
32
338
418

ZeroStack · Answer 2 · 2017-10-19T00:07:03.297

3

Using lubridate

library(lubridate)

parse_date_time(as.character(20130107), "%Y%m%d")

If you wanted to just extract certain elements of the date, this is easy with strftime. For example, just the year:

strftime(parse_date_time(as.character(20130107), "%Y%m%d"), "%Y")

edited Oct 19 '17 at 00:07

answered Jun 15 '15 at 15:09

ZeroStack

1,049
1
13
25

Convert numbers to dates

2 Answers2

Linked

Related