Home > mailing lists

count number of weeks?? - Mailing list pgsql-sql

From
Subject	count number of weeks??
Date	March 5, 2001 16:59:16
Msg-id	20010305175516.18950.qmail@nwcst315.netaddress.usa.net Whole thread Raw
Responses	Re: count number of weeks?? (Christopher Sawtell <csawtell@xtra.co.nz>)
List	pgsql-sql

Tree view

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

pgsql-sql by date:

From: Jie Liang
Date: 05 March 2001, 16:29:06
Subject: Re:

From: "Jeff S."
Date: 05 March 2001, 16:59:22
Subject: How do I use text script containing SQL?

count number of weeks?? - Mailing list pgsql-sql

Previous

Next