count number of weeks??

From: <rocael(at)usa(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: count number of weeks??
Date: 2001-03-05 10:55:16
Message-ID: 20010305175516.18950.qmail@nwcst315.netaddress.usa.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all!
I wonder how in PG7.0.2 I can count the number of weeks from a date field that
I have in a table, lets say:

table trial has in its fields start_date as sysdate(), and now I want to do a
select that will give me the number of weeks from now [sysdate()] to the
start_date.

Thanks for the help!
Rocael.

____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=1

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Boulat Khakimov 2001-03-05 14:11:14 Re: Two way encryption in PG???
Previous Message Sondaar Roelof 2001-03-05 08:39:47 RE: Help creating rules/triggers/functions