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