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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
- Re: [SQL] calculating interval praveen vejandla
- Re: [SQL] calculating interval Dan Langille
- Re: [SQL] calculating interval Jean-Luc Lachance
- Re: [SQL] calculating interval Jeff Boes