Home » SQL & PL/SQL » SQL & PL/SQL » Timestamp Query
icon5.gif  Timestamp Query [message #248207] Thu, 28 June 2007 05:02 Go to next message
Messages: 123
Registered: February 2007
Senior Member
Hi all,

how to find the no of days between two timestamps and no of hours between two timestamp( i am using GMT time)...Is there any special reserved word for us to find this query?send me the query
Re: Timestamp Query [message #248231 is a reply to message #248207] Thu, 28 June 2007 06:34 Go to previous messageGo to next message
Messages: 107
Registered: February 2007
Location: Chennai
Senior Member

Post the actual requirement with the code you have tried. It would be easier for others to answer the question.What do you mean by difference between two timestamps?

[Updated on: Thu, 28 June 2007 06:39]

Report message to a moderator

Re: Timestamp Query [message #248234 is a reply to message #248207] Thu, 28 June 2007 06:41 Go to previous message
Michel Cadot
Messages: 63929
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you try minus?

Previous Topic: Is there any concept of "Illipses" in Oracle?
Next Topic: bind variable parsing in execute immediate
Goto Forum:

Current Time: Wed Oct 26 22:58:15 CDT 2016

Total time taken to generate the page: 0.09966 seconds