Creating a date/time search function in Postgres.

Поиск
Список
Период
Сортировка
От Sean O'Loughlin
Тема Creating a date/time search function in Postgres.
Дата
Msg-id d946c6270609010934x2ad01a6bqaba2cc38859b0b29@mail.gmail.com
обсуждение исходный текст
Ответы Re: Creating a date/time search function in Postgres.
Re: Creating a date/time search function in Postgres.
Список pgsql-general
Hi all,

I have a question about how a certain function would look. Basically, what I want to do is having something that would take in a 'from' date (day, month, year) and a 'to' date (also day, month and year) and then spit back a series of records whose timestamps fall between those two dates. How would a basic function like that look like? Would I need to have separate integers for the day month and year, or is there a date/time object I could use instead? I am somewhat new to Postgres, but not SQL altogether.

Thanks in advance.

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

Предыдущее
От: Bob Pawley
Дата:
Сообщение: Serial Updating
Следующее
От: timasmith@hotmail.com
Дата:
Сообщение: One step install, up and running?