SQL Timestamp Questions and Answers

Recent IT Questions

1 - 2 of 2
<<PREVIOUS 1 NEXT>>

PL/SQL

Hi Experts, I would like to mentione here i was trying to test one package and found the package has a procedure named SET() which hav UPDATE on Report table and INSERT on A_R table in same transaction Both the above mentioned tables hav a tim_upt column which s given as systimestamp and...

View Answer   |  Feb 17 2009  10:47 AM GMT
PL/SQL block, SQL Timestamp, UPDATE statement
asked by Inprise

  525 pts.

Block Of Activity

I have timestamps for events stored as datetime's. Given a starting datetime, is there a way to find the block of timestamps where: 1. At least one timestamp is within 1 hour of the given datetime. 2. No individual timestamp is greater than 1 hour after the previous timestamp (or possibly before...

View Answer   |  Dec 7 2007  7:45 AM GMT
SQL, SQL Timestamp
asked by VentureFree

  45 pts.

1 - 2 of 2
<<PREVIOUS 1 NEXT>>