Skip site navigation (1) Skip section navigation (2)

Need help writing SQL statement

From: D A GERM <dgerm(at)shepherd(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Need help writing SQL statement
Date: 2005-06-29 14:59:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
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 using:
SELECT COUNT(time_stamp) FROM table WHERE time_stamp BETWEEN 
20050629100000 and 20050631100000;

Any help would be appreciated.

Thanks in advanced for any help


"Well then what am I supposed to do with all my creative ideas- take a bath and wash myself with them? 'Cause that is what soap is for" (Peter, Family Guy)

In response to


pgsql-general by date

Next:From: Eric D NielsenDate: 2005-06-29 15:01:04
Subject: Re: Advice on merging two primary keys...
Previous:From: ketan shahDate: 2005-06-29 14:48:00
Subject: how to use pg_dump and then restored onto development server

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group