postgreSQL for months consume..

[raynoel]

Hello agaiN!!

I used

age(timestamp 'enrollmentdate') AS "Months Consume" ;

to see how many months they alreaady consume, but error message state that

****
ERROR: invalid input syntax for type timestamp: "enrollmentdate"
***

though when you try to query the enrollmentdate it will
show you the date of the enrollment... why is it?
any bright ideas?

pls..
thnx..

 

[feherke]

Hi

So enrollmentdate is a field of type date ? Then just remove the single quotes ( ' ) :

age(timestamp enrollmentdate) AS "Months Consume" ;

Feherke.

http://rootshell.be/~feherke/