DateTime Calculation

'I am writing code that deactivates a user's account if there are 3 failed
login tries within a 10 minute period. I need to take data from a
smallDatetime field in a recordset with only 1 record and subtract 10
minutes. Can someone give me the correct syntax?
Thank you.SELECT DATEADD(MINUTE, -10, GETDATE())
"Jinjer" <Jinjer@.discussions.microsoft.com> wrote in message
news:129C22B7-2B0F-4968-9DCF-5FA99B4244B8@.microsoft.com...
> 'I am writing code that deactivates a user's account if there are 3 failed
> login tries within a 10 minute period. I need to take data from a
> smallDatetime field in a recordset with only 1 record and subtract 10
> minutes. Can someone give me the correct syntax?
> Thank you.|||Thanks. I'll give it a go tomorrow.
--
Jinjer
"Aaron Bertrand [SQL Server MVP]" wrote:

> SELECT DATEADD(MINUTE, -10, GETDATE())
>
> "Jinjer" <Jinjer@.discussions.microsoft.com> wrote in message
> news:129C22B7-2B0F-4968-9DCF-5FA99B4244B8@.microsoft.com...
>
>