•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 391,952 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,813 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 6160 | Replies: 4
 |
•
•
Join Date: Oct 2005
Posts: 3
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
How would you calculate the difference between two dates?
•
•
Join Date: Aug 2005
Location: El Paso, TX
Posts: 225
Reputation:
Rep Power: 4
Solved Threads: 5
Posting Whiz in Training
•
•
•
•
Originally Posted by bradleyc
How would you calculate the difference between two dates?
use DATEDIFF(datepart,startdate,enddate)
the datepart is the part of the date you want the difference of, days, months, years.
•
•
Join Date: Oct 2005
Posts: 3
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
so apparently i do something like ..
SELECT DATEDIFF(dd, '12/5/2002 22:00', '12/6/2002 09:00')
can i do something like
SELECT DATEDIFF(dd, DateOfRego, CaseClosed)
SELECT DATEDIFF(dd, '12/5/2002 22:00', '12/6/2002 09:00')
can i do something like
SELECT DATEDIFF(dd, DateOfRego, CaseClosed)
•
•
Join Date: Aug 2005
Location: El Paso, TX
Posts: 225
Reputation:
Rep Power: 4
Solved Threads: 5
Posting Whiz in Training
Re: sql*plus or pl/sql question •
•
•
•
Originally Posted by bradleyc
so apparently i do something like ..
SELECT DATEDIFF(dd, '12/5/2002 22:00', '12/6/2002 09:00')
can i do something like
SELECT DATEDIFF(dd, DateOfRego, CaseClosed)
you can do that, so long as you assign appropriately either pl-sql, PHP or ASP. What are you running on??
sample...
DateOfRego="12/5/2002 22:00"
CaseClosed="12/6/2002 09:00"
SELECT DATEDIFF(dd, '" & DateOfRego & "', '" & CaseClosed & "')
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Linear Mode
- sql 2005 to sql 2000 (MS SQL)
- using PL\SQL to drop PK from table (Oracle)
- Team Lead C#, ASP.NET, VB.NET, Web Services, SQL - Los Angeles, CA (Web Development Job Offers)
- Please help me out with MySQL query (MySQL)
- Sql Injuction (Computer Science and Software Design)
- IO and Embedded SQL (Java)
- oracle or sql server2000, which is best? (Oracle)
- ASP and SQL ? (MS SQL)
- Microsoft SQL Server 2000 Exploit! (MS SQL)
Other Threads in the MS SQL Forum
- Previous Thread: In which (really) important ways is SQL 2000 better than Access 2003?
- Next Thread: INSERT CLAUSE using SUB-QUERY
