Well it is a avaya phone system database. It does not let me into the actual database, it just gives me the tables.I can do simple equations with the tables. So I cannot write any select statements. TI_AUXTIME1 is the table that records time of lunch and TI_AUXTIME2 is the table that records...
Hello,
It has been awhile since I have had to any database programing. I want to find out the sum of the two tables minus one hour and 15 minutes.
Example
sum(TI_AUXTIME1)+sum(TIAUXTIME2)-01:15:00
Any help would be appreciated
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.