Diana:
This should get you started:
http://www.sqlcourse.com
Best,
Yvette Ingram
Brainbench Certified ColdFusion 4.5 Programmer
Email: ingramrecruiting@erols or
[EMAIL PROTECTED]
ICQ: 21200397
----- Original Message -----
From: "Diana Nichols" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 03, 2001 5:14 PM
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
