How to calculate the difference in seconds b/w 2 timestams?

mayank007 · Post by **mayank007** » Mon Oct 04, 2004 6:38 pm

Hi,

I need to compute the difference between 2 timestamps and store the results in "seconds" in the target table. This field is a duration field and so the timestamp be for the same day. How do i implement this. Can this be done using iconv and oconv functions?

Thanks,
Mayank

kduke · Post by **kduke** » Mon Oct 04, 2004 8:29 pm

Do a search this has been covered a lot. Ray posted several routines. If you cannot find it then let us know.

chulett · Post by **chulett** » Mon Oct 04, 2004 10:52 pm

I was digging around in my Favorites to help on a different topic and stumbled across this post. The KBA version. Thought I would save you some searching.

So there's three tips in one here:

1) The answer to your question.
2) The fact that with almost 35,000 posts here, most questions have been asked and answered before.
3) That you have the ability to save things you'd like to refer to again in your Favorites list.

Enjoy!

mayank007 · Post by **mayank007** » Tue Oct 05, 2004 12:34 am

Hey ,

thanks a lot. I will try out this routine tomorrow. I guess this should solve my problem.

Mayank :D