Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

where table.date>mydate/today???

Status
Not open for further replies.
atashan

atashan

MIS
Joined
Sep 27, 2001
Messages
1
Location
US
How do you ask for a condition to display records whose date (column date in some table) is greater than today's date or a certain date?

Any hints would be great, I am new to SQL Server queries, can anyone help?

Thanks!
 
Sort by date Sort by votes
select * from database..tablename
where date_col > '01/01/01'

or where date_col > getdate()

RajD
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question Question
Is "IF EXISTS()..." better than "IF (SELECT COUNT...) > 0"
Replies
4
Views
3K
gmmastros
gmmastros
grnzbra
  • Locked
  • Question Question
USE <database> With sp_executesql
Replies
1
Views
635
bborissov
bborissov
mchambers
  • Locked
  • Question Question
Error - in Where clause
Replies
2
Views
382
mchambers
mchambers
jchewsmith
  • Locked
  • Question Question
Crystal formula to find the prior month end date from today
Replies
7
Views
426
jchewsmith
jchewsmith
appelq
  • Locked
  • Question Question
SQL Server 2012 Bulk Insert CSV File where a column (Cust Name) May have commas
Replies
7
Views
719
appelq
appelq

Part and Inventory Search

Sponsor

Back
Top