SQL Time Difference

Subtracting Date Time in MSSQL

--YEAR
SELECT DATEDIFF(year, '2012-12-31', '2013-01-01')

--Quarter
SELECT DATEDIFF(quarter, '2012-01-01 23:59:59', '2013-01-01 00:00:00')

--Month
SELECT DATEDIFF(month, '2012-12-31 23:59:59.9999999', '2013-02-01 00:00:00.0000000')

--Day
SELECT DATEDIFF(day, '2012-12-01 23:59:59.9999999', '2012-12-31 00:00:00.0000000')

--Week
SELECT DATEDIFF(week, '2013-06-01 23:59:59.9999999', '2013-06-30 00:00:00.0000000')

--Hour
SELECT DATEDIFF(hour, '2013-06-30 08:30:00.0000000', '2013-06-30 17:30:00.0000000')

--Minute
SELECT DATEDIFF(minute, '2013-06-30 08:30:00.0000000', '2013-06-30 17:30:00.0000000')

--Second
SELECT DATEDIFF(second, '2013-06-30 08:30:00.0000000', '2013-06-30 08:30:25.0000000')

--Millisecond
SELECT DATEDIFF(millisecond, '2005-12-31 23:59:59.9999999', '2006-01-01 00:00:00.0000000');

Comments

Greenbelt Chapel

Chapel of Santo Niño de Paz Greenbelt Chapel, also known as the Chapel of Santo Niño de Paz, is one of those unique Roman Catholic chapels located in Makati, Philippines, inside the Greenbelt Mall complex. This open-air, circular-design edifice was built in the early 1980s and is regarded as unique compared with most conventional churches. Designed to blend in with nature, the chapel architecture seems to float above a garden oasis in the middle of Makati business district, all but covered with greenery. It is a favorite among the employees and passersby, since it has daily Masses, confessions, and other religious activities. Its minimalist style, in which concrete elements are utilized symbolically and complemented by natural elements, also evokes silent and meditative settings among visitors and regular mass goers.

YouTube

Uploaded YouTube Shorts and Videos. Please subscribe to my YouTube . Thank you! Load More

Rizal Park (Luneta Park)

Luneta Park, formally named Rizal Park, is a massive 58-hectare urban oasis located in the midst of Manila, Philippines. A place teeming with historical value and part of the largest parks in Asia, as it is the place where Dr. José Rizal, the country's national hero, was executed way back in 1896, giving rise to the revolution against Spanish colonization in the Philippines. And in the center of this park, as one approaches it, stands the monumental granite structure, the Rizal Monument, to which sentinels are posted. Both locals and tourists throng to the place to do their tribute. The lawns are very large, but little can be said, although these avenues flanked by trees and those peculiarly designed gardens like the Chinese and Japanese Gardens do serve to be a perfect retreat amidst the hustle and bustle of the city. Save the green spots, there are cultural and recreational facilities in Luneta Park. Colored light and music shows are staged at the Musical Dancing Fountain, and...

Jon Raz

Search This Blog