| From: | "Seema Noor" <seema_56(at)yahoo(dot)com> | 
|---|---|
| To: | <pgsql-sql(at)postgresql(dot)org> | 
| Cc: | <pgsql-novice(at)postgresql(dot)org> | 
| Subject: | time difference | 
| Date: | 2001-05-25 15:12:16 | 
| Message-ID: | 004601c0e52d$1af00340$0100a8c0@noor | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-novice pgsql-sql | 
i want to calculate the session time. my query is this
select now() - '2001-05-19 12:09:00+5;
it gives the difference in date and difference in time separately. if the
current time is greater than the second time then it gives simply their
difference but i want to calcutate the session time from these two times.
if now() = 2001-05-25 01:00:00+5
and second timestamp = 2001-05-24 23:00:00+5
then how can i get their time differernce EQUAL TO '3:00:00' instead of '21:00:00 ago' ?
and is there a way to get the total time difference including the date factor involved i.e.
if now() = 2001-05-25 23:00:00+5
and second timestamp = 2001-05-24 01:00:00+5
then is there any function to get their difference equal to '46:00:00' instead of '1 22:00:00' ?
please reply me soon.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Milen | 2001-05-25 17:40:51 | batch file | 
| Previous Message | Tatsuo Ishii | 2001-05-25 01:02:51 | Re: Charset and encoding | 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2001-05-25 15:34:15 | Re: Large Objects Documentation | 
| Previous Message | Roberto Mello | 2001-05-25 14:49:03 | Large Objects Documentation |