Duplicate date records

  • Thread starter Thread starter McDuck
  • Start date Start date
M

McDuck

In (SELECT [timestamp] FROM [Dec07] As Tmp GROUP BY [timestamp],[modem_id]
HAVING Count(*)>1 And [modem_id] = [Dec07].[modem_id])

Works fine - but brings back duplicates in mm/dd/yyyy hh:mm:ss

I need it in mm/dd/yyyy hh:mm format (no seconds) - if it is sent within
seconds - its a duplicate - if it is sent over 60 seconds - its a new record

Thanks for your help - Ian McDoanld
 
So you need to round the time value to the nearest number of seconds?
Click to expand...

I think the OP requires minutes rounded *down* (rather than nearest)
e.g.

SELECT #2008-01-22 08:48:59# AS test_value,
DATEADD('N', DATEDIFF('N', #1990-01-01 00:00:00#, test_value),
#1990-01-01 00:00:00#) AS test_value_minutes_rounded_down

Jamie.

--
 
Back
Top