Just subtract the dates from each other works ok for me.
psql=# select
to_date('2002-12-16','YYYY-MM-DD')-to_date('2002-10-29','YYYY-MM-DD');
?column?
----------
48
(1 row)
or
psql=# select
to_date('2002-12-16','YYYY-MM-DD')-to_date('1999-10-29','YYYY-MM-DD') as
days ;
days
------
1144
(1 row)
Simon
Bruno Wolff III wrote:
>On Fri, Jan 10, 2003 at 12:35:37 -0800,
> Hunter Hillegas <lists@lastonepicked.com> wrote:
>
>
>>I am trying to calculate the number of days between two dates.
>>
>>
>
>Just subtract the dates from each other. The result will be an integer type
>with the number of days between the two dates.
>
>
>
>>date_shipped: 2002-12-16
>>date_of_request: 2002-10-29
>>date_difference: 18
>>NOT OK - it is more days than this.
>>
>>
>
>You are just comparing the days of the month, not the actual days.
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
>