Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Feb 14, 2000

Dynamic Views Using the System Date

Question:
I have a user who wants me to create a dynamic search view where the data retrieved is effective within the last six months using the system date.

Is there some sort of date editing on the select clause that I can use (i.e., where the effective date is between [sysdate] and [sysdate–6 months])?

Answer:
Well, the getdate() function returns the current date. The dateadd function can add or subtract from a date.

So

select * from [tablename]
where
[name of date field ] > dateadd(mm,-6,getdate())
will find all records that are within the past six months. If you want, you could also use the same select within a create view statement:
create view [view name] as select...
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date