Re: getting no days problem

[Thom Brown <thombrown@xxxxxxxxx>]

2009/1/29 sanjeev kumar <vannalaspgsql@xxxxxxxxx>

Hi all,

I have written procedure as follows:
---------------------------------------------------------
--procedure begin
Create Procedure sp_getNoOfDays(
                         ip_startDate    IN date,
                         ip_endDate      IN date,
                         op_noofdays     OUT bigint
                        )
i

Create Procedure?  Are you sure this isn't for Oracle?  Shouldn't this be a function?

Thom