[thelist] Using Wildcards and Dates in SQL Server

Gary McPherson genyus at ingenyus.net
Tue Jun 17 14:25:18 CDT 2003

> > SELECT * FROM curEvents WHERE DATEPART(month, eDate) = 6 AND 
> > DATEPART(year, eDate) = 2003
> Well whaddya know. Thanks, Gary!
> --ken

Glad I could help, but Jason made a further improvement which is the way
to go if you're trying to compare the eDate field to the current as
opposed to a fixed date.

All the best,


More information about the thelist mailing list