Date-time conversion in R

Question

I have created a file something like this:

> filesInside
         Date         Time
1  01:09:2013 10:35:49.997 
2  01:09:2013 10:35:50.197

How could I possibly make a function using

as.POSIXct()

and I should be get something like this:

> as.POSIXct("2013-09-01 10:35:50")
[1] "2013-09-01 10:35:50 NZST"

How can I make it as a function?

My code so far:

DateTime <- as.POSIXct(paste(filesInside$Date, filesInside$Time), format="%Y%m%d %H%M%S")

Appreciate a bit of help please. Cheers

A small reproducible example, the expected output, and what you have tried - very nice first question! +1! — Henrik, Oct 25 '13 at 00:33
I think this shows the local time. try the code yourself by typing `as.POSIXct("2013-09-01 10:35:50")` in R and see what code you get. Do you get something different? — jeff1234, Oct 25 '13 at 01:36

Henrik · Answer 1 · 2013-10-25T00:42:09.010

3

You may try this. The order of date-time components and separators in format should reflect those in the object to be converted. See also ?strptime.

with(filesInside,
     as.POSIXct(paste(Date, Time),
                format = "%d:%m:%Y %H:%M:%S",
                tz = "NZ"))
# [1] "2013-09-01 10:35:49 NZST" "2013-09-01 10:35:50 NZST"

edited Oct 25 '13 at 00:42

answered Oct 25 '13 at 00:11

Henrik

65,555
14
143
159

score 2 · Answer 2 · answered Oct 25 '13 at 00:20

library(lubridate)
dmy_hms(apply(filesInside, 1, paste, collapse=" "), tz="NZ")
# [1] "2013-09-01 10:35:49 NZST" "2013-09-01 10:35:50 NZST"

lubridate here is a cinch, especially with its collection of dmy_hms, ymd etc functions.

To properly paste across rows, simply use apply(<data.frame>, 1, paste, collapse=" ")

Date-time conversion in R

2 Answers2