Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.

ID: 14740, New Entry Created By Rodger Van Kirk

by Rodger Van Kirk Email:

Download Details
FTP  download also available 0 bytes
CDN Login Required to Download. (You will be redirected to the login page if you click on the Download Link)
To download this, you must have registered:
A free membership

For Delphi, Version 1.0  to 1.0 19 downloads
Copyright: No significant restrictions

Size: 0 bytes
Updated on Mon, 22 May 2000 00:00:00 GMT
Originally uploaded on Mon, 22 May 2000 00:00:00 GMT
I'm having problems trying to use the extract function in local SQL. I have a database which has a series of data with a TimeStamp field and I'm trying to get the SUMs of some values based on the month and year. ie.
1/1/99 5.3
1/2/99 6.0
1/3/99 2.2
2/1/99 1.2

I would like to have a result that showed
Jan-99 13.5
Feb-99 1.2

I tried using the extract and the SUM and group by
but I always get an error saying group by doesn't support the Extract
how can I accomplich this?

   Latest Comments  View All Add New

Move mouse over comment to see the full text

Could not retrieve comments. Please try again later.

Server Response from: ETNACDC04