[thelist] Using Wildcards and Dates in SQL Server

Ken Kogler ken.kogler at curf.edu
Tue Jun 17 12:35:05 CDT 2003

> Ummm... I imagine he'd want to use the date for that record, not the
> current date:
> SELECT * FROM curEvents WHERE DATEPART(month, eDate) = 6 AND
> DATEPART(year, eDate) = 2003

Well whaddya know. Thanks, Gary!


More information about the thelist mailing list