Hi,
to remove the time from a date column I would use (SQL 2000\2005 ETC)
SET DATEFORMAT DMT
SELECT
CONVERT(DATETIME, CONVERT(VARCHAR, MY_DATE_TIME_FIELD, 103))
FROM
XXX
GROUP BY
CONVERT(DATETIME, CONVERT(VARCHAR, MY_DATE_TIME_FIELD, 103))
>>> On 03/09/2008 at 5:58 pm, in message <[EMAIL PROTECTED]>, Claude Raiola
>>> <[EMAIL PROTECTED]> wrote:
I am trying to group my cfquery output by date however as the values the date
column also include the time stamp this is causing a problem.
Is there a way that i can make the query only group by the date portion of the
datetime stamp as this will then allow me to group all records of the same date
together and then sort said grouped records by the complete date value which
includes the date value.
<CFQUERY NAME="mycalendar1" dbtype="query">
select starttime, [from] as sentfrom, endtime, subject, duration, location,
message, organizer, htmlmessage, requiredattendees
from mycalendar
group by starttime, endtime, subject, sentfrom, duration, location, message,
organizer, htmlmessage, requiredattendees
order by starttime
</cfquery>
Regards
Claude Raiola
B.Econ (Acc), B.Hot.Mngt.
Websites:
www.AustralianAccommodation.com
www.SAMARIS.NET
www.WebSiteSolutions.com.au
Mobile: 0414 228 948
<BR
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cfaussie?hl=en
-~----------~----~----~----~------~----~------~--~---
