In Asp we are able to find the time diffrence between two time/date values with the help of Datediff function. But this will return the value either in hour or in minute or in second. I want to know how to convert or display the data in Hour:Minute:Second (00:00:00) format if the Datediff function returns the value in seconds.
rsUsers1.open "SELECT sum(datediff(s,(LoginTime),(LogoutTime))) AS Prod FROM project_login where project_login.Name='" &mname1&"' and project_login.InputDate>='"&fdate&"' And project_login.InputDate<='"&tdate&"'",Conn
I am extracting the Sum of time diffrence between two times of a particular date in seconds and assigning the value to a variable as
in the next line we when use the formulae
I am getting the error message
Microsoft VBScript runtime (0x800A005E)
Invalid use of Null
this error message I am geeting on the same line number on which we have the line of DateADD function.