How do I select the DatePart from date field?

[Smapty]

I can't understand why this isn't working...

<CFQUERY NAME="GetSessions" DATASOURCE="#sourcename#">
SELECT DatePart(d, start_time) AS DayPart
FROM Sessions
</CFQUERY>

 

[Smapty]

Nevermind, I think I got it now....

<CFQUERY NAME="GetSessions" DATASOURCE="#sourcename#">
SELECT day(start_time) AS DayPart, start_time, stop_time, title
FROM Sessions
GROUP BY start_time, stop_time, title
</CFQUERY>

 

[r937]

your GROUP BY is superfluous, unless your table actually contains multiple rows with the same combination of start_time, stop_time, and title

r937.com | rudy.ca