TIMESTAMP SUBTRACTION
От | Madhavi Daroor |
---|---|
Тема | TIMESTAMP SUBTRACTION |
Дата | |
Msg-id | NHBBKMLNGKEMDMCGAMFNAEHECAAA.madhavi@zoniac.com обсуждение исходный текст |
Ответы |
Re: TIMESTAMP SUBTRACTION
Re: TIMESTAMP SUBTRACTION Re: TIMESTAMP SUBTRACTION Re: TIMESTAMP SUBTRACTION Re: TIMESTAMP SUBTRACTION (retry, list is bouncing emails) |
Список | pgsql-general |
Hi All, When I subtract 2 timestamp variables in postgres 2.3.1, I get an interval value. Eg: SELECT TO_TIMESTAMP('05-21-2003 00:00:00','mm-dd-yyyy') - TO_TIMESTAMP('04-30-2003 00:00:00','mm-dd-yyyy'); Result: 21 days --------- This is an interval But what I need is a numeric value. Ie; 21 and NOT 21 days. I need to compare this difference with a numeric value in my WHERE clause like this WHERE TIMESTAMP('05-21-2003 00:00:00','mm-dd-yyyy') - TO_TIMESTAMP('04-30-2003 00:00:00','mm-dd-yyyy') > 30 But if I do this....I get wrong results. How do I do such a comparison? Or How to I get a Numeric value after the subtraction? Please reply SOON !!! Thanx, Madhavi Daroor
В списке pgsql-general по дате отправления: