SQL Statement, Retrieve Expired Accounts

Please support our MS SQL advertiser: Intel Parallel Studio Home
Reply

•
•
Join Date: Jul 2009
Posts: 12
Reputation: ishamputra is an unknown quantity at this point 
Solved Threads: 0
ishamputra ishamputra is offline Offline
Newbie Poster

SQL Statement, Retrieve Expired Accounts

 
0
  #1
Aug 3rd, 2009
hello, i would like to retrieve data on which the endDate < date.now....something like that..
thanks
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2008
Posts: 3
Reputation: hkb261 is an unknown quantity at this point 
Solved Threads: 1
hkb261 hkb261 is offline Offline
Newbie Poster

Re: SQL Statement, Retrieve Expired Accounts

 
1
  #2
Aug 4th, 2009
select *
from data
where enddatetime <= getdate()
Reply With Quote Quick reply to this message  
•
•
Join Date: Feb 2009
Posts: 3,432
Reputation: sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of 
Solved Threads: 621
Sponsor
sknake's Avatar
sknake sknake is offline Offline
.NET Enthusiast

Re: SQL Statement, Retrieve Expired Accounts

 
0
  #3
Aug 4th, 2009
Welcome to DaniWeb hkb261! Please use code tags when posting code on daniweb.

[code=sql]
...query here...
[/code]


But your answer was correct
Last edited by sknake; Aug 4th, 2009 at 5:50 am.
Scott Knake
Custom Software Development
Apex Software, Inc.
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the MS SQL Forum


Views: 255 | Replies: 2
Thread Tools Search this Thread



Tag cloud for MS SQL
"last autogrowth business connectingtodatabaseinuse count cursor data database dateadd datepart day" dbsize deadlock delete_trigger exploit getdate hack highperformancecomputing hpc hpcserver2008 ibm iis limit loop maximum microsoft ms mssql multiple multithreading news number password permission position query reporting result security server services sets single source sql sql-injection sqlserver sqlserver2005 subtype supercomputing supertype tables uniqueid update view weekday
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC