i'll let u borrow my SQL server programming book (err, 45 dollars vlaue or
sumpin)
it's really good, taught me lots.
just pay for shipping :P
-----Original Message-----
From: Diana Nichols [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 4:15 PM
To: CF-Talk
Subject: query dates
Can someone tell me how to specify part of a date in SQL 2000?
i.e. WHERE DatePart('m',eventdate) = #thismonth#
Worked fine in Access....
Also, until I can get more SQL books, is there a good online resource for
stuff like this? All I can find are basic tutorials and performance tips....
TIA!!
*************
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374
"One man's magic is another man's engineering." ---Lazarus Long
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
