How to check if a timestamp is a whole hour

Question

I'm building a python application where I get a lot of data from various timeseries (ranging from 1 minute to 1 day). I would only like to store the times (unix timestamps) that are exactly on a whole hour (xx:00 minutes). How do I build this check?

Is a simple if timestamp % 3600 == 0: save the timestamp sufficient enough? Or is there a better way?

@Hackaholic Yes that is exactly what I mean.And I see I used modulo 60. That should be modulo 3600 (I want whole hours, not minutes) — Wouter Luberti, Nov 06 '14 at 21:36

score 5 · Answer 1 · answered Nov 06 '14 at 21:30

5

use datetime.fromtimestamp

from datetime import datetime  

ts = 1415309268
cts = datetime.fromtimestamp(ts)
print(cts.minute==00)

If you want seconds also:

cts.minute==00 and cts.second==00

answered Nov 06 '14 at 21:30

Padraic Cunningham

176,452
29
245
321

cts.second u can use in here – Hackaholic Nov 06 '14 at 21:31
@Andrey, op only seemed to want minutes, I will add seconds in case – Padraic Cunningham Nov 06 '14 at 21:31
@PadraicCunningham he said whole hour, so possibly that he didn't himself think of seconds :) – Andrey Nov 06 '14 at 21:33
@Andrey, I went by (xx:00 minutes) but you are probably correct ;) – Padraic Cunningham Nov 06 '14 at 21:33

score 5 · Accepted Answer · answered Nov 06 '14 at 21:43

5

The timestamp is in seconds, so the time mod 3600 should be zero.

if timestamp % 3600 == 0:
    # save the timestamp-value tuple

This is enough, you don't have to make a datetime object and check the minute and second for every timestamp you get.

answered Nov 06 '14 at 21:43

espang

673
6
6

How to check if a timestamp is a whole hour

2 Answers2