[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 451
  • Last Modified:

TSQL current time minus 1 minute

Hi experts

I want to use the current time -1 minute in SQL, does anyone know the syntax for this or could point me in the right direction?
0
MrDavidThorn
Asked:
MrDavidThorn
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
select dateadd( minute, -1, getdate() )
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now