Base: Time query criterion

[DinoGuy]

I have data from a weather station that reports a record about every twenty seconds or so. The data-set has separate fields for formatted for date and time. I’d like to run a query that lists all the records that occur when the minutes of each record equal ‘00’ (top of the hour). What I want to end up with is about three records at the top of each hour from which I can pick one value.

What criteria would I enter to have the query spit out records where the minutes in the time field equal ‘00’?

[librebel]

Hello @DinoGuy,

To select all records from your table where the Time field contains a minutes value that equals zero, you could write this SQL statement :

SELECT * FROM "yourTable" WHERE MINUTE( "yourTimeField" ) = 0

HTH, lib