Re: [SQL] date_part stored procs

2004-03-28 Thread Tsoloane Moahloli
"Tsoloane Moahloli" <[EMAIL PROTECTED]> writes: > SELECT INTO len * FROM (SELECT > ((date_part(''year'',age(docDate))*12)+(date_part(''month'',age(docDat > e > AS a; > The problem is that it does not run and I cannot

[SQL] date_part stored procs

2004-03-26 Thread Tsoloane Moahloli
Title: Message Making me lose my cool.  Here is how it goes:   I have the following Stored Proc, Which I intend to find the age in months of a date...     CREATE FUNCTION interval_months(TIMESTAMP) RETURNS INTEGER AS ' DECLARE  docDate ALIAS FOR $1;  len INTEGER; BEGIN  SELECT INTO len * FR