How keep only date variable without time-field string

Question

My question takes a general aspect comparing to which was proposed here How to remove time-field string from a date-as-character variable?.

In fact, suppose I have this date type variable:

> head(DataDia$Date)
[1] "2016-09-13 15:56:30.827" "2016-12-12 13:39:17.537" "2016-09-16 21:57:24.977" "2016-09-23 11:19:22.010"
[5] "2017-01-11 20:06:58.490" "2016-10-21 23:40:43.927"

How do I delete all time-field strings and just keep the date format. SO that I get this:

> head(DataDia$Date)
[1] "2016-09-13" "2016-12-12" "2016-09-16" "2016-09-23"
[5] "2017-01-11" "2016-10-21"

Note please that I am working on a data table. So I need a way using data.table operations.

score 6 · Accepted Answer · answered Feb 20 '18 at 07:49

6

Just use as.Date(DataDia$Date).

answered Feb 20 '18 at 07:49

drmariod

11,106
16
64
110

score 1 · Answer 2 · answered Feb 20 '18 at 08:04

1

You Can use:

as.POSIXct(Df$Date,format='%Y-%m-%d',tz= "UTC")

answered Feb 20 '18 at 08:04

Rahul shah

185
2
16

score 0 · Answer 3 · edited Feb 20 '18 at 17:29

0

Combining as.Date and as.character

x = c("2016-09-13 15:56:30.827", "2016-12-12 13:39:17.537", "2016-09-16 21:57:24.977", "2016-09-23 11:19:22.010",
        "2017-01-11 20:06:58.490", "2016-10-21 23:40:43.927")

y = as.character(as.Date(x, format = "%Y-%m-%d"))

y
[1] "2016-09-13" "2016-12-12" "2016-09-16" "2016-09-23" "2017-01-11" "2016-10-21"

edited Feb 20 '18 at 17:29

David Arenburg

91,361
17
137
196

answered Feb 20 '18 at 07:52

Edu

903
6
17

Why do you load lubridate? – Roland Feb 20 '18 at 07:52
That's true. It could work as a base solution. Thanks – Edu Feb 20 '18 at 07:54
2

What's the point of `as.character`? – David Arenburg Feb 20 '18 at 17:30

How keep only date variable without time-field string

3 Answers3