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: 20021122142609.11784.qmail@webmail31.rediffmail.com (view raw or flat)
Thread:
Lists: 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

Responses

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-2014 The PostgreSQL Global Development Group