Finding Date and Time differences in Seconds

[Learning123]

Hi,
I've been working on a project for automation of data input stats and I am having a hard-time figuring out how to find the "Seconds" differece in the beginning and the ending time. below is a example of what my table looks like

Begin_T | End_T
-----------------------------------------
11/02/02 11:00:00 AM |11/03/02 1:55:00 PM

total difference is 26:55:00 which equals = 96900 seconds

I'm trying to find a SQL (access) statement to this problem.
As always Thanks a lot for taking the time to help me out!!

jeff

 

[petermeachem]

You can use

datediff('s,FirstDate,SecondDate) Peter Meachem
peter@accuflight.com

Support Joanna's Bikeathon

http://www.accuflight.com/blue_peter_bikeathon_2002.htm

 

[petermeachem]

You can use

datediff('s',FirstDate,SecondDate) Peter Meachem
peter@accuflight.com

Support Joanna's Bikeathon

http://www.accuflight.com/blue_peter_bikeathon_2002.htm