You use the SQL DatePart function
select DatePart(mm, columnname) as month
from foo
--K
-----Original Message-----
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 14, 2000 3:52 PM
To: [EMAIL PROTECTED]
Subject: Help with SQL
I have a date and time field in the form of 8/14/00 in an Access database. I
want to be able to select out the distinct months in all the fields. It
seems that I can't do that.
Do I have to redo the database and separate the month? Or do I have to
process the query with some kind of CF code?
Sebastian
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
