Re: [GENERAL] Date manipulation

[Hadley Willan]

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 <[EMAIL PROTECTED]> writes:
>   Hadley Willan <[EMAIL PROTECTED]> 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