modified_date TIMESTAMP(6) WITHOUT TIME ZONE DEFAULT "statement_timestamp"(),
select modified_date,from clients WHERE modified_date BETWEEN '2016-06-13' AND '2016-09-13'
select modified_date,from clients WHERE modified_date >='2016-06-13' AND modified_date < '2016-09-13'
select modified_date from clients ORDER BY modified_date ASC
modified_date ------------------- 2015-07-11 17:23:40 2016-09-13 20:00:51 2016-09-13 20:00:51 2016-09-13 20:00:51 2016-09-13 20:00:51
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных