Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
postgreSQL for months consume..
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...- raynoel
- Thread
- Replies: 1
- Forum: PostgreSQL Inc.: PostgreSQL
-
How view remaining months.
I was able to get the expiry date of a certain company in my database but I have problem on how to view their remaining months before the expiry date. I have function name kh_expiry which check the expiry date of a company. SELECT DISTINCT kh_expiry(enrollmentdate), companyidfk FROM...- raynoel
- Thread
- Replies: 3
- Forum: PostgreSQL Inc.: PostgreSQL
-
How to sum up the row? please see the code below.
I wanted to sum up the total in table expenses "debit" row. currently it's connected with 3 tables for the debit. Hope you can help me here. ------no. one query-------- SELECT a.debit, a.credit, a.action_date,d.compname, b.labfee, b.payee FROM expenses a INNER JOIN memberlaboratory b ON...- raynoel
- Thread
- Replies: 7
- Forum: PostgreSQL Inc.: PostgreSQL
