[thelist] Using Wildcards and Dates in SQL Server
David Mitchell
dmitchell at oproma.com
Tue Jun 17 14:07:08 CDT 2003
Yeah, good point - I knew I was close...
-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On Behalf Of Ken Kogler
Sent: Tuesday, June 17, 2003 1:35 PM
To: thelist at lists.evolt.org
Subject: RE: [thelist] Using Wildcards and Dates in SQL Server
> 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!
--ken
--
* * Please support the community that supports you. * *
http://evolt.org/help_support_evolt/
Evolt.org conference in London, July 25-27 2003. Register today at
http://evolt.org.uk
For unsubscribe and other options, including the Tip Harvester
and archives of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !
More information about the thelist
mailing list