Login
Products
Sales
Support
Downloads
About
Home
»
Technical Support
»
ElevateDB Technical Support
»
Support Forums
»
ElevateDB SQL
»
View Thread
View Thread
The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
grouping by timestamp
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