Re: Getting the week of a date - Mailing list pgsql-sql

On Monday 16 February 2004 12:10, Kumar wrote:
>
> test=# select date_trunc('week',current_date + ('5 month')::INTERVAL);
> ERROR:  TIMESTAMP units 'week' not supported

Try EXTRACT(week FROM ...)

--  Richard Huxton Archonet Ltd