pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Luis Magaña <joe666@gnovus.com>
To: Postgresql General Mail List <pgsql-general@postgresql.org>
To: Postgresql SQL Mail List <pgsql-sql@postgresql.org>
Subject: Start and End Day of a Week
Date: 07 Feb 2003 14:57:58 -0600
Message-ID: <1044651478.1124.3.camel@kerberus> (raw)

Hi, 

how can I get the first and last day of a week given the year and the
week number ???

example

week 3 of 2003 starts in Jan 12th and ends on Jan 18th.

how to know the last two values given the year and the number of week ?

thanks.

Best Regards.

-- 
Luis Magaña.
Gnovus Networks & Software.
www.gnovus.com




view thread (2+ messages)  latest in thread

Message-ID: <1044651478.1124.3.camel@kerberus>
Permalink:  ../1044651478.1124.3.camel@kerberus/
Also on:    postgresql.org/message-id/1044651478.1124.3.camel@kerberus

 · 

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: joe666@gnovus.com, pgsql-general@postgresql.org
  Subject: Re: Start and End Day of a Week
  In-Reply-To: <1044651478.1124.3.camel@kerberus>

* 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