[freetds] Query - Sum(data) by Date?

Jorge Cordero jorge.cordero at gmx.net
Thu Nov 10 11:03:26 EST 2005


This is not usually the topic of FreeTDS, but I'll give it a shot:

select 	Object, 
	sum (Level) TotalLevel, 
	convert(datetime, convert(varchar(10), MyDateTimeField,121),
121) OnlyTheDay
>from 	MyTable
group by 
	Object, 
	convert(datetime, convert(varchar(10), MyDateTimeField,121),
121) 

Suggestion, convert this in a view, so you can deal with it as usual, 
with our loved snippets of code to read data.




Shaun Craig <s.craig at andronics.com> wrote:
(11/10/2005 10:47)

>How do i go about this, i have a single table 'Flow' which holds values 
>for a particular object for a date, ie
>
>'Object'      'Level'      'Date/Time'
>
>Object1      2.0            Nov 09 2005 10:02AM
>Object1      3.3            Nov 09 2005 11:32AM
>Object1      1.2            Nov 09 2005 13:12PM
>etc........
>Object1      3.4            Nov 10 2005 04:12AM
>Object1      0.1            Nov 10 2005 11:23PM
>etc...
>
>I want a query which will sum(level) for each date, so result will look 
>like the following
>
>'Object'      'Total Level for Date'      'Date'
>
>Object1      6.5                                    Nov 09 2005
>Object1      3.5                                    Nov 10 2005
>
>Any ideas, had a look on the web but you need to sign up to stuff to see 
>solutions, not an option.
>
>Thanks,
>
>Shaun.
>_______________________________________________
>FreeTDS mailing list
>FreeTDS at lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds




More information about the FreeTDS mailing list