How would you calculate the difference between two dates?
bradleyc
0
Newbie Poster
extofer
-2
Posting Whiz in Training
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.
bradleyc
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)
extofer
-2
Posting Whiz in Training
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 & "')
bradleyc
0
Newbie Poster
DateOfRego="12/5/2002 22:00"
CaseClosed="12/6/2002 09:00"
What if thet are based simply on dates, no times?
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.