how to do calculation of dates?

Dev Shed Forums Sponsor:

October 5th, 2004, 10:40 AM

shivanjali

Registered User

Join Date: Jun 2004

Posts: 11

Time spent in forums: < 1 sec
Reputation Power: 0

how to do calculation of dates?

HI,
getdate() gives me today's date. I have a sql query which returns me a date. I want to see if the difference between today's date and the date returned by sql query is 12 months(1 year) or less. If yes I want to print it.
(If the difference is more than 12 months or 1 year i don't want to consider that record.)

Example:
how to do calculate:
10/05/2004-10/3/2003

October 5th, 2004, 02:56 PM

r937

SQL Consultant

Join Date: Feb 2003

Location: Toronto Canada

Posts: 17,581

Time spent in forums: 1 Month 3 Weeks 6 Days 5 h 20 m 45 sec
Reputation Power: 949

use the DATEDIFF function

__________________
r937.com | rudy.ca

October 5th, 2004, 03:00 PM

cmv131

Contributing User

Join Date: Jun 2004

Posts: 33

Time spent in forums: 1 Day 2 h 34 m 16 sec
Reputation Power: 5

Code:

case when 
Datediff(mm, (select date from...), getdate()) <= 12
then ....
else  ....
end

Or it should be something like that

October 5th, 2004, 03:07 PM

r937

SQL Consultant

Join Date: Feb 2003

Location: Toronto Canada

Posts: 17,581

Time spent in forums: 1 Month 3 Weeks 6 Days 5 h 20 m 45 sec
Reputation Power: 949

more like this:

Code:

select foo, bar, datecolumn
  from yourtable
 where datediff(m,datecolumn,getdate()) <= 12

Viewing: Dev Shed Forums > Databases > MS SQL Development > how to do calculation of dates?

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump