Postgres Pro
Downloads
Home   >   mailing lists

date_trunc('week', '2005-01-01'::TIMESTAMP) - Mailing list pgsql-general

From pgsql-general@list.coretech.ro
Subject date_trunc('week', '2005-01-01'::TIMESTAMP)
Date
Msg-id 43327BF0.9090402@list.coretech.ro
Whole thread Raw
Responses Re: date_trunc('week', '2005-01-01'::TIMESTAMP)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Howard Cole
Date:
Subject: Re: Win32 Backup and Restore of large databases.
Next
From: "A. Kretschmer"
Date:
Subject: Re: date_trunc('week', '2005-01-01'::TIMESTAMP)