Timestamp Difference

  • Thread starter Thread starter Francis Phillips
  • Start date Start date
F

Francis Phillips

Hi,

Is it possible to get difference between the timestamps on the same table to
get an indication of time between entries into the same table?

Thanks

Frank
 
Hi,


If the data is in a field of the table, sure


SELECT a.pk, b.pk, a.timeStamp-b.timeStamp
FROM myTable As a INNER JOIN myTable As b
ON ...


where the ON clause precise which relations has to be validated (between the
records) from which we desire to compute the difference.



Hoping it may help,
Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting timestamps 2
timestamp handle 5
DateDiff Conversion 7
Syntax error in CREATE TABLE statement. (Error 3290) 3
AVG(COUNT(timestamp))...this will not work, what am I doing wrong? 1
HOW TO OBTAIN ONLY THE DATE OF A timestamp FIELD 3
Date Timestamp 1
Complex Query Question - Parsing web logs 2

Back
Top