Skip site navigation (1) Skip section navigation (2)

calculating interval

From: "praveen vejandla" <praveen_vejandla(at)rediffmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: calculating interval
Date: 2002-11-22 14:26:09
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
Dear All,

Is there any way in postgresql to calculate the interval between 
two times excluding specific days,specific duration.

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 

Thanks and Regards,


pgsql-sql by date

Next:From: Dan LangilleDate: 2002-11-22 14:36:15
Subject: Re: calculating interval
Previous:From: Dan LangilleDate: 2002-11-22 13:00:50
Subject: Re: connectby questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group