DATEDIFF in SQL

[rmatthew]

More of a SQL Syntax question than .NET - sorry

 

I am using an Access database and need the minimum value of datediff(seconds,time1,time2).

 

here is what I have:

 

Select min(datediff(seconds,tmstamp,endtime)) as elapsedtime, recindx from chronology order by recindx

 

broke it down to this (but it still doesn't work)...

 

SELECT datediff(seconds,tmstamp,endtime) as elapsedtime,recindx from Chronology ORDER by recindx

 

Specific error is too few param. expected 1

 

HELP :)

[Nerseus]

You want to use 's' instead of seconds, as in:

SELECT datediff('s', tmstamp, endtime) as elapsedtime,recindx from Chronology ORDER by recindx

 

-nerseus

[rmatthew]

thanks much - works great ...