EMAIL PROTECTED] On Behalf Of Andrew Sullivan
Sent: Thursday, April 29, 2004 3:42 PM
To: Pgsql-General
Subject: Re: [GENERAL] Timestamp problems...wrong weeks.
On Thu, Apr 29, 2004 at 02:42:49PM -0400, Campano, Troy wrote:
>
> This is causing my reports to print out incorrect data.
> D
On Thu, Apr 29, 2004 at 02:42:49PM -0400, Campano, Troy wrote:
>
> This is causing my reports to print out incorrect data.
> Do you know why this would happen? Am I doing something wrong?
I think you may be misunderstanding what "W" means:
week of month (1-5) (The first week starts on the first
Title: Timestamp problems...wrong weeks.
Hello,
I’m having a problem with timestamps in postgresql.
I run the following query to pull dates in this format:
WEEK/MONTH/YEAR
However the data says that April 28th 2004 was in week 4 of April and that April 29th 2004 was in week 5 of april.
