Hello,

I am trying to truncate times to only the hour using floor so that I can merge all data for that hour. However, using the code below, the times are off by seconds/minutes

gen mergehour= floor(time/3600000)*3600000
format mergehour %tc

time mergehour
04may2015 08:10:00 04may2015 08:00:10
15may2019 13:59:00 15may2019 12:59:27

I can't figure out why this would happen, any suggestions?

Thanks