pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Ireneusz Pluta <ipluta@wp.pl>
To: Jorge Godoy <jgodoy@gmail.com>
Cc: Sergey Konoplev <gray.ru@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Week to date function
Date: Sat, 27 Mar 2010 21:22:18 +0100
Message-ID: <4BAE68FA.8000803@wp.pl> (raw)
In-Reply-To: <m2w175c742d1003271108p773ebaa7y4fedf008762ed12c@mail.gmail.com>
References: <4BAB2C15.8090406@wp.pl>
	<c3a7de1f1003250244p440b8244t57319b742fa680f0@mail.gmail.com>
	<4BAC9107.5070701@wp.pl>
	<m2w175c742d1003271108p773ebaa7y4fedf008762ed12c@mail.gmail.com>

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.

view thread (10+ messages)  latest in thread

Message-ID: <4BAE68FA.8000803@wp.pl>
Permalink:  ../4BAE68FA.8000803@wp.pl/
Also on:    postgresql.org/message-id/4BAE68FA.8000803@wp.pl

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: ipluta@wp.pl, jgodoy@gmail.com, gray.ru@gmail.com
  Subject: Re: Week to date function
  In-Reply-To: <4BAE68FA.8000803@wp.pl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox