Re: date_part stored procs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: tsoloane(at)mimecast(dot)co(dot)za
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: date_part stored procs
Date: 2004-03-26 23:03:13
Message-ID: 28231.1080342193@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Tsoloane Moahloli" <tsoloane(at)mimecast(dot)co(dot)za> writes:
> SELECT INTO len * FROM (SELECT
> ((date_part(''year'',age(docDate))*12)+(date_part(''month'',age(docDate))))
> AS a;

> The problem is that it does not run and I cannot for the life of me tell
> why.

I think you miscounted parentheses.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-03-27 03:23:27 Re: autocommit
Previous Message Bruno Wolff III 2004-03-26 21:53:03 Re: order of results