[thelist] Using Wildcards and Dates in SQL Server

[Gary McPherson]

> -----Original Message-----
> From: thelist-bounces at lists.evolt.org 
> [mailto:thelist-bounces at lists.evolt.org] On Behalf Of David Mitchell
> Sent: 17 June 2003 17:58
> To: thelist at lists.evolt.org
> Subject: RE: [thelist] Using Wildcards and Dates in SQL Server
> 
> 
> So you're trying to get all records for June 2003? Try this:
> 
> SELECT * from curEvents where DATEPART(month, GETDATE()) = 6 
> and DATEPART(year, GETDATE()) = 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

HTH,

Gary