calculating interval - Mailing list pgsql-sql

From praveen vejandla
Subject calculating interval
Date
Msg-id 20021122142609.11784.qmail@webmail31.rediffmail.com
Whole thread Raw
Responses Re: calculating interval  (Dan Langille <dan@langille.org>)
List pgsql-sql
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 sun days are coming, i want to 
ignore all sundays in between,i want to ignore certain timings(say 
10.00 AM to 5:00PM)s also,then how can I get the duration in this 
way.

Thanks and Regards,
Praveen


pgsql-sql by date:

Previous
From: Dan Langille
Date:
Subject: Re: connectby questions
Next
From: Dan Langille
Date:
Subject: Re: calculating interval