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
