Forums
This topic is locked
Datediff
Posted 27 Jun 2003 14:40:42
1
has voted
27 Jun 2003 14:40:42 Brendan Antunez posted:
I have a database with table having two different time stamps StartTime and EndTime. I'm using Ultradev to display the results on a webpage in ASP. I'm using the SQL functionality. Here is the SQL commands I'm using but I'm getting the error "Microsoft [ODBC Microsoft Access Driver] To few parameters excected 1. Here is the code I'm using, Please help!
SELECT StartTime, EndTime, datediff("h",StartTime, EndTime) AS calctime
FROM Scanning