query with times

  • Thread starter Thread starter Tonic
  • Start date Start date
T

Tonic

Hi,

I have now:

SELECT *
FROM Control
WHERE TIMEVALUE(DatetimeField) > HFActivitat;

But I need timevalue(datetime field) + 10 minutes. How can I obtain this
result?

Thanks!
Tonic
 
I resolved the query with this code line:

SELECT *
FROM Control
WHERE TIMEVALUE(timeField) > DATEADD('n', 10,AnotherTimeField);

Saludos,
Tonic
 
Back
Top