Query where todays date = a date in a table 1

[Sandman007]

I have a table with "name" and "graduationdate". Is there a way I can make a query to automatically pull the names that are graduating today (having the query automatically pull todays date from the system)?

I am not sure about how to do this.
All I have so far is:

SELECT tableA.name WHERE tableA.graduationdate = ???

Thanks for any help or suggestions!
Sandman007

 

[RobertT687]

SQL syntax:
SELECT tableA.name WHERE tableA.graduationdate = getdate()

Access syntax:
SELECT tableA.name WHERE tableA.graduationdate = date()

 

[Sandman007]

THANKS!

 

[tlbroadbent]

getdate() will return system date and time. Querying for dates that match getdate() probably won't work. Convert the datetime of getdate() to date only. here is one way you can do that.

SELECT tableA.name
WHERE tableA.graduationdate = convert(char(11), getdate()) Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.