Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Mon, Oct 29 2007 11:27 AM	Permanent Link
revort	How can I group by the date portion of a timestamp column? thanks Randy
Mon, Oct 29 2007 12:48 PM	Permanent Link
Roy Lambert NLH Associates Team Elevate	revort CAST the timestamp as a date? Roy Lambert
Mon, Oct 29 2007 3:21 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Randy, << How can I group by the date portion of a timestamp column? >> Roy is correct - just group on: GROUP BY CAST(MyTimestampColumn AS DATE) -- Tim Young Elevate Software www.elevatesoft.com