time dates - Search results in mailing lists

2015-03-11 07:19:59 | Re: (Sergey Konoplev)

time_range). Например, (device_id % 100, now()::date). Старые партиции, которые страрше 3х лет, COPY

2011-05-19 18:30:17 | Помогите написать выборку. (Peter Teslenko)

date | timestamp without time zone | not null default now() request_type_id | integer | default 0 request

2007-10-12 15:00:22 | дата-время в базе отличаются от системных (Alexander Kuprijanov)

date; echo 'select CURRENT_TIME;' | psql MyBase Fri Oct 12 14:51:10 MSD 2007 timetz

2007-03-29 09:21:44 | Re: Чудо дивное планировщик явил !!! (silly_sad)

time zone | not null default (date_trunc('day'::text, now()) + '1 day'::interval) extra | text

2006-12-04 20:59:17 | Re: SELECT ... WHERE ... IN (SELECT ...) -> SELECT ... WHERE (... OR ... ) (Anton)

time_month" btree (date_trunc('month'::text, collect_time)) "n_traffic_login_id" btree (login

2006-12-04 20:49:31 | Re: SELECT ... WHERE ... IN (SELECT ...) -> SELECT ... WHERE (... OR ... ) (Anton)

time_month" btree (date_trunc('month'::text,collect_time)) "n_traffic_login_id" btree (login

2005-05-24 08:53:17 | Re: Создание и (Viktor Vislobokov)

DATE, ttime TIME, src_ip INET NOT NULL, src_port INT NOT NULL, dst_ip INET