TRY
TO_CHAR(date_col, 'MONTH')
Kore Peterson
Database Development Specialist
SEH - Minneapolis
612.758.6739
"Gyrus"
<[EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]>
reeuk.com> cc:
Subject: Re: SQL question
10/08/2002
09:07 AM
Please respond
to cf-talk
----- Original Message -----
From: "Thane Sherrington" <[EMAIL PROTECTED]>
> Is there a way to use a Select query to get just the month out of a date
in
> a SQL query? I have a database that has a date field in it (so 04-10-02)
> and I want to select all the records from a specific month.
---------------------------
Flicking through my reference books, SQL Server and MySQL both have a
month() function. Not sure about Access, check MSDN. Or - and this is
something that has reduced my CF-Talk posts no end - try it out! ;-)
- Gyrus
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
- [EMAIL PROTECTED]
work: http://www.tengai.co.uk
play: http://www.norlonto.net
- PGP key available
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
