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 doesnt 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 ...