| From: | Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> |
|---|---|
| To: | Arcel Labrada Batista <alabradab(at)uci(dot)cu>, pgsql-es-ayuda(at)postgresql(dot)org |
| Subject: | Re: trabajo con fechas |
| Date: | 2009-12-06 00:53:11 |
| Message-ID: | 3073cc9b0912051653y32d8af49l5c383686bd758706@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
2009/12/4 Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
>
> Ahora caigo en cuenta que esto falla al cambiar de año
>
Aja! esta es la manera:
with q as (
select *
from generate_series('2009-10-01 00:00:00'::timestamp with time zone,
'2010-12-04 00:00:00'::timestamp with time zone,
'1 day'::interval) as foo
)
select * from q
where extract(week from foo + '1 week'::interval) = extract(week from
current_date)
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergio Gabriel Rodriguez | 2009-12-06 22:36:47 | Re: Fwd: Acelerar VACUUM |
| Previous Message | Raúl Andrés Duque Murillo | 2009-12-06 00:06:26 | Re: Ayuda con cadena de conexion ODBC windows XP SP 3 desde VFP a POSTGRESQL 8.4 |