Need help writing SQL statement

Поиск
Список
Период
Сортировка
От D A GERM
Тема Need help writing SQL statement
Дата
Msg-id 42C2B74C.2030409@shepherd.edu
обсуждение исходный текст
Ответ на Re: How to query pgsql from a BASH script ?  (Roman Neuhauser <neuhauser@sigpipe.cz>)
Ответы Re: Need help writing SQL statement  (Jeffrey Melloy <jmelloy@visualdistortion.org>)
Список 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
whatsoap is for" (Peter, Family Guy) 



В списке pgsql-general по дате отправления:

Предыдущее
От: ketan shah
Дата:
Сообщение: how to use pg_dump and then restored onto development server
Следующее
От: Eric D Nielsen
Дата:
Сообщение: Re: Advice on merging two primary keys...