I have been trying to write an sql statement that returns the same hours
in a time stamp no matter what the date.
I can to pull same hours on the the same days but have not been able to
figure out how to pull all the same hours no matter what the date.
Here is the one sql statement I have been
D A GERM wrote:
I have been trying to write an sql statement that returns the same
hours in a time stamp no matter what the date.
I can to pull same hours on the the same days but have not been able
to figure out how to pull all the same hours no matter what the date.
Here is the one sql
On Wed, 2005-06-29 at 13:20, Jeffrey Melloy wrote:
D A GERM wrote:
I have been trying to write an sql statement that returns the same
hours in a time stamp no matter what the date.
I can to pull same hours on the the same days but have not been able
to figure out how to pull all the
thank you all for your help.
this solved it:
SELECT count(*) FROM table where date_part('hour', time_stamp) in (10, 11);
Scott Marlowe wrote:
On Wed, 2005-06-29 at 13:20, Jeffrey Melloy wrote:
D A GERM wrote:
I have been trying to write an sql statement that returns the same
hours