Extracting Data by time

[MAY]

I have a data logger that collects data every 5 seconds from 2 sources. I
have imported the data into 2 tables. How can I extract data every 5 minutes
at the hh:mm:00 time value (i.e. at 0 seconds) – so that I can perform
calculations on the extracted data for the same time values

 

[Stefan Hoffmann]

hi,

I have a data logger that collects data every 5 seconds from 2 sources. I
have imported the data into 2 tables. How can I extract data every 5 minutes
at the hh:mm:00 time value (i.e. at 0 seconds) – so that I can perform
calculations on the extracted data for the same time values

I would consider using a base query like

SELECT
CDate(Format([yourDate], "\#m\/d\/yyyy hh\:nn\#"))
AS AggregationDateTime,
*
FROM
yourTable


mfG
--> stefan <--