SQLism

Logging and Blogging SQL Server Experiences.

Showing posts with label Minutes. Show all posts
Showing posts with label Minutes. Show all posts

Monday, September 22, 2014

Script to get elapsed time from start of current day in SQL Server

How to get elapsed time in Seconds, Minutes, Hours from start of current day?


SELECT DATEDIFF(SECOND, 0, Cast(GETDATE() AS TIME)) -- In Seconds

SELECT DATEDIFF(MINUTE, 0, Cast(GETDATE() AS TIME)) -- In Minutes

SELECT DATEDIFF(HOUR, 0, Cast(GETDATE() AS TIME)) -- In Hours
Posted by SQLism at 1:52 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: current, day, elapsed, from, get, Hours, How, in, Minutes, Script, Seconds, SQL Server, start of, time, to
Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ▼  2020 (6)
    • ▼  July (1)
      • Reorganize all indexes in a Database in SQL Server.
    • ►  March (1)
    • ►  February (4)
  • ►  2018 (3)
    • ►  August (3)
  • ►  2017 (10)
    • ►  December (1)
    • ►  October (1)
    • ►  June (1)
    • ►  May (1)
    • ►  February (4)
    • ►  January (2)
  • ►  2016 (7)
    • ►  December (1)
    • ►  November (3)
    • ►  October (1)
    • ►  September (1)
    • ►  August (1)
  • ►  2015 (10)
    • ►  September (1)
    • ►  April (9)
  • ►  2014 (53)
    • ►  October (19)
    • ►  September (33)
    • ►  June (1)
  • ►  2013 (12)
    • ►  October (2)
    • ►  September (1)
    • ►  August (5)
    • ►  July (1)
    • ►  March (1)
    • ►  February (1)
    • ►  January (1)
  • ►  2012 (9)
    • ►  September (1)
    • ►  August (6)
    • ►  July (2)
Simple theme. Theme images by luoman. Powered by Blogger.