days_between() function
The days_between() function determines the truncated number of full days between two time stamps.
Syntax
The days_between() function has the following
syntax:
int = days_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 days between the
t1 and t2 values.
Example
select days_between('1996-02-27 06:12:33' , '1996-03-01 07:12:33');
DAYS_BETWEEN
--------------
3
(1 row)