Solved

TSQL - Length of days between two dates

Posted on 2008-10-15
2
703 Views
Last Modified: 2008-10-15
I have a table that contains dates when the record was created.  Using a T-SQL query how would I be able to figure out how many days have passed since that record was created.  For example GETDATE() - RecordCreatedDate = Number of Days.

Any help is appreciated.  Thanks!
0
Comment
Question by:RTCexpert
  • 2
2 Comments
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 22724464
dateadd(d, recordcreated,getdate())
0
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 250 total points
ID: 22724467
sorry... datediff

datediff(d, recordcreated,getdate())
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
tempdb log contention 16 50
SQL Server tables join on parse list 6 33
Stored Proc - Rewrite 42 59
Index and Stats Management-Specific tables 8 22
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question