Re: Week to date function

From: Ireneusz Pluta <ipluta(at)wp(dot)pl>
To: Jorge Godoy <jgodoy(at)gmail(dot)com>
Cc: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Week to date function
Date: 2010-03-27 20:22:18
Message-ID: 4BAE68FA.8000803@wp.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Jorge Godoy pisze:
> Are you sure?
>
> http://en.wikipedia.org/wiki/ISO_8601
snip
>
> As Jan 1st, 2010 happened on a Friday, it was on week 53 of 2009.
you are right, thanks for pointing that out.

I didn't check the opposite way like this:

select date_part('week', '2010-01-01'::date);
date_part
-----------
53

I need to recheck my code.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Hiltibidal, Rob 2010-03-27 21:31:18 Re: Week to date function
Previous Message Jorge Godoy 2010-03-27 18:08:53 Re: Week to date function