I need to select the date from a dateTime field as its own variable... for
grouping later in the output.<CFQUERY NAME="GetSessions"
DATASOURCE="#sourcename#">
SELECT DatePart(d, start_time) AS DayPart, start_time
FROM Sessions
</CFQUERY>