[SQL] calculating interval

2002-11-22 Thread praveen vejandla
Dear All, Is there any way in postgresql to calculate the interval between two times excluding specific days,specific duration. Ex: timestamp1 : 2002-10-01 10:30AM timestamp2 : 2002-15-01 04:50PM suppose if i need the difference between timestamp1,timestamp2 but i don't want to count how many

[SQL] averaging interval values

2002-11-12 Thread praveen vejandla
Hi All, I have a table with one varchar field that contains time intervals. Is there any way to average or sum those intervals in a table ? Table name : test field name : t2 (varchar(40)) it contains all intervals as below t2 1:01:01 0:25:15 7:09:01 8:09:05 Is there any way to average or