Re: Date manipulation

Yes, I'm not worried about an exact DST. The date items are stored with
Timestamp Timezone.

Thanks to everybody for your technical tips and help.

Hadley

On Mon, 2004-04-19 at 16:42, Tom Lane wrote:

> Bruno Wolff III <bruno(at)wolff(dot)to> writes:
> > Hadley Willan <hadley(dot)willan(at)deeperdesign(dot)co(dot)nz> wrote:
> >> dateRange = ''now''::date - ( 7 * '1 week'::interval );
>
> > If you actually are using a date you don't have to use an interval as
> > the number subtracted will be in days. So you could just use
> > current_date - (7 * 7);
>
> Good point --- in fact, that's probably exactly what Hadley wants,
> because "date - integer" will yield a date and not a timestamp. The
> form involving interval will do odd things when crossing a DST
> transition.
>
> regards, tom lane