November 21, 2008 05:33pm pst

11.26.2004 at 10:20AM PST, ID: 21221220

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.8

group by date where date is not defined as 00:00:00 - 23:59:00

Asked by gripe in PostgreSQL Database

Tags: group, date

Hi all,

I have a table with both a date and time column. I would like to obtain a count of all rows that occur on a 'date', but the date starts at 18:00 the day prior and ends at 18:00 the current day. How can I do this?

I can select from that time frame (for example, for today) by doing:

select foo from bar where (time >= '18:00:00' and date = '11/25/04') and (time < '18:00:00' and date = '11/26/04');

Now how can I group by (for instance) all of the days in november that fall within this time frame?

Let me know if I need to clarify, hopefully I've expressed this properly. I'd like the most efficient way of doing this.Start Free Trial

Keywords: group by date where date is not define…

	Title
1	Foo & Bar
2	Efficiency theory-a
3	Aliases in GROUP BY commands - S…
4	What is the most efficient memory-siz…
5	T-SQL needs to be more efficient
6	group and frame

Loading Advertisement...

20081112-EE-VQP-42 - Hierarchy

1. earthman2 55,603
2. gheist 38,585
3. ivanovn 38,295
4. adrpo 28,765
5. grant300 11,464
6. drazen_n... 11,400
7. fridom 8,000
8. angelIII 7,400
9. thewild 6,700
10. TomasHelgi 6,325
11. DrCabbage 6,000
12. lesouef 5,900
13. hernst42 5,500
13. rokov 5,500
15. Rawdust 5,300
16. rabroersma 5,210
17. lssaul 5,000
18. mwvisa1 4,500
19. BondinASP 4,000
19. dportas 4,000
21. tusharkan... 3,900
22. sanjooz 3,800
23. ee_rlee 3,750
24. mark_wills 3,600
25. hielo 3,500

1. earthman2 462,736
2. gheist 112,604
3. ivanovn 105,932
4. m1tk4 62,612
5. adrpo 48,159
6. grant300 34,286
7. rjkimble 31,347
8. ravenpl 20,699
9. fridom 17,000
10. GGuzdziol 16,660
11. TomasHelgi 11,825
12. angelIII 11,400
12. drazen_n... 11,400
14. hernst42 8,300
15. Ghitza 7,600
16. ldbkutty 6,730
17. thewild 6,700
18. jkr 6,250
19. gripe 6,000
19. DrCabbage 6,000
21. lesouef 5,900
22. Robson 5,855
23. ushastry 5,500
23. rokov 5,500
25. Rawdust 5,300

group by date where date is not defined as 00:00:00 - 23:59:00

Asked by gripe in PostgreSQL Database

Tags: group, date

About this solution