date_trunc('week', '2005-01-01'::TIMESTAMP)

From: "pgsql-general(at)list(dot)coretech(dot)ro" <pgsql-general(at)list(dot)coretech(dot)ro>
To: pgsql-general(at)postgresql(dot)org
Subject: date_trunc('week', '2005-01-01'::TIMESTAMP)
Date: 2005-09-22 09:40:00
Message-ID: 43327BF0.9090402@list.coretech.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


select date_trunc('week', '2005-01-01'::TIMESTAMP) returns '2006-01-02
00:00:00'

is this the intended result or is some kind of a bug ?
the result should not be '2004-12-27 00:00:00' ?

thanks,
Razvan Radu

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stas Oskin 2005-09-22 10:01:40 Re: Postgres locks table schema?
Previous Message Howard Cole 2005-09-22 09:13:09 Re: Win32 Backup and Restore of large databases.