Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Barilla
-
Timestamp subtract and Interval data type
Thank you Dagon. Now I know what I have to do. -Barilla- Barilla
- Post #5
- Forum: Oracle: All versions
-
Timestamp subtract and Interval data type
Dagon, Thank you for the interest. Let's take two timesstamp literals for example. So the actual query looks like: select timestamp'2002-12-31 12:00:00' - timestamp'1995-02-14 08:30:00' from dual; And I wonder if I can have the result like ' 7 10 17 03:00:00' in a simple query. Thanks...- Barilla
- Post #3
- Forum: Oracle: All versions
-
Timestamp subtract and Interval data type
Hi, Is there a simple query that gives two timestamps difference in a format like 'yyyy mm dd hh:mm:ss'? ANSI only defines year to month or day to second interval data types (and several variations) but nothing like 'year to second'. I wonder if there is a way to get the answer in a pretty...- Barilla
- Thread
- Replies: 4
- Forum: Oracle: All versions
