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
How to calculate the difference in seconds b/w 2 timestams?
Moderators: chulett, rschirm, roy
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!
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!
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers