Handling dates when we switch to daylight savings time and back

by

I had a similar problem with hydrological data from a sensor. My timestamps were in UTC+1 (CET) and did not switch to daylight saving time (UTC+2, CEST). As I didn’t want my data to be one hour off (which would be the case if UTC were used) I took the %z conversion specification of strptime. In ?strptime you’ll find:

%z Signed offset in hours and minutes from UTC, so -0800 is 8 hours
behind UTC.

For example: In 2012, the switch from Standard Time to DST occured on 2012-03-25, so there is no 02:00 on this day. If you try to convert “2012-03-25 02:00:00” to a POSIXct-Object, 

> as.POSIXct("2012-03-25 02:00:00", tz="Europe/Vienna")
[1] "2012-03-25 CET"

you don’t get an error or a warning, you just get date without the time (this behavior is documented).

Using format = "%z" gives the desired result: 

> as.POSIXct("2012-03-25 02:00:00 +0100", format="%F %T %z", tz="Europe/Vienna")
[1] "2012-03-25 03:00:00 CEST"

In order to facilitate this import, I wrote a small function with appropriate defaults values:

as.POSIXct.no.dst <- function (x, tz = "", format="%Y-%m-%d %H:%M", offset="+0100", ...)
{
  x <- paste(x, offset)
  format <- paste(format, "%z")
  as.POSIXct(x, tz, format=format, ...)
}

> as.POSIXct.no.dst(c("2012-03-25 00:00", "2012-03-25 01:00", "2012-03-25 02:00", "2012-03-25 03:00"))
[1] "2012-03-25 00:00:00 CET"  "2012-03-25 01:00:00 CET"  "2012-03-25 03:00:00 CEST"
[4] "2012-03-25 04:00:00 CEST"

More Related Contents:

  1. as.Date(as.POSIXct()) gives the wrong date?
  2. How to prevent ifelse() from turning Date objects into numeric objects
  3. How to convert Excel date format to proper date in R
  4. Split date-time column into Date and time variables
  5. efficiently generate a random sample of times and dates between two dates
  6. Change timezone in a POSIXct object
  7. How to parse milliseconds?
  8. How do you convert POSIX date to day of year?
  9. How to change the default time zone in R?
  10. calculating time difference in R
  11. Date conversion from POSIXct to Date in R
  12. Convert seconds to days: hours:minutes:seconds
  13. Understanding dates and plotting a histogram with ggplot2 in R
  14. How to Parse Year + Week Number in R?
  15. .NET DateTime.Now returns incorrect time when time zone is changed
  16. How to join two dataframes by nearest time-date?
  17. How to determine if date is a weekend or not (not using lubridate)
  18. Convert UTC DateTime to another Time Zone
  19. Rounding time to nearest quarter hour
  20. Change day of the month in a Date to first day (01)
  21. Checking if Date is Between two Dates in R
  22. extract hours and seconds from POSIXct for plotting purposes in R
  23. Convert hours:minutes:seconds to minutes
  24. R: merge two irregular time series
  25. Calculating Time Difference between two columns
  26. How to tell if a timezone observes daylight saving at any time of the year?
  27. Find all date ranges for overlapping start and end dates in R
  28. How to detect Ambiguous and Invalid DateTime in PHP?
  29. R datetime series missing values
  30. How to calculate time difference with previous row of a data.frame by group

Leave a Comment