Understanding the Limitations of R's as.Date Function for Parsing Hourly Timestamps Using POSIXct Instead