How to parse milliseconds?

r datetime time-series strptime
signalseeker picture signalseeker · Jan 27, 2010 · Viewed 45k times · Source

How do I use strptime or any other functions to parse time stamps with milliseconds in R?

time[1]
# [1] "2010-01-15 13:55:23.975"
strptime(time[1], format="%Y-%m-%d %H:%M:%S.%f")
# [1] NA
strptime(time[1], format="%Y-%m-%d %H:%M:%S")
# [1] "2010-01-15 13:55:23"`

Answer

Aniko picture Aniko · Jan 27, 2010

Courtesy of the ?strptime help file (with the example changed to your value):

 z <- strptime("2010-01-15 13:55:23.975", "%Y-%m-%d %H:%M:%OS")
 z # prints without fractional seconds
 op <- options(digits.secs=3)
 z
 options(op) #reset options

Related questions

R: merge two irregular time series

I have two multivariate time series x and y, both covering approximately the same range in time (one starts two years before the other, but they end on the same date). Both series have missing observations in the form of …

Read More
Which R time/date class and package to use?

I have a limited time series exposure in R. So, I wonder which time/date class (and associated package) would be most appropriate to start with. Among the plethora of packages available at CRAN task view, I so far favor …

Read More
extract hours and seconds from POSIXct for plotting purposes in R

Suppose I have the following data.frame foo start.time duration 1 2012-02-06 15:47:00 1 2 2012-02-06 15:02:00 2 3 2012-02-22 10:08:00 3 4 2012-02-22 09:32:00 4 5 2012-03-21 13:47:00 5 And class(foo$start.time) returns [1] "POSIXct" "POSIXt" I'd like to create a plot of foo$duration v. foo$…

Read More