C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

How to find the date difference in SQL Server

Posted Date: 05 Mar 2008 Resource Type: Code Snippets Category: SQL

Posted By: Clement Member Level: Gold
Rating:

Points: 10

This sample code shows how to find the difference between two dates in SQL Server

This will display the difference of two dates in days.
GETDATE() returns Current Date


								
SELECT DATEDIFF(day,'01/01/2008',GETDATE())

This will display d difference of two dates in months.


								
SELECT DATEDIFF(month,'01/01/2008',GETDATE())

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Syntax of DISTINCT
	Previous Resource: To retriev the first 10 records from table in sql server with out using top key word
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

conference calls