count number of weeks?? - Mailing list 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