weeks_between() function
The weeks_between() function determines the truncated number of full weeks between two time stamps.
Syntax
The weeks_between() function
has the following
syntax:
int = weeks_between(timestamp t1, timestamp t2);
The t1 value
specifies the beginning time stamp.
The t2 value specifies the ending time stamp.
Returns
The function returns the truncated number
of full weeks between the
t1 and t2 values.
Example
select weeks_between('1996-02-27 06:12:33' , '1996-03-05 07:12:33');
WEEKS_BETWEEN
---------------
1
(1 row)