🚀 go-pugleaf

Hi All

I am writing a sql query to extract a bunch of info from a SQL7
server. The problem I am having is that I need to match the times
between 2 tables as a where condition, but the times are always 3
Minutes 46 seconds different. ie something like

select whatever
from tablea A, Tableb B
where a.time - b. time = 3.46

The problem with this is that the time field is expressed as date/time
as follows : '8/29/99 10:53:29 AM' in both tables, so a.time-b.time =
'12/31/99 11:56:54pm'

What the Hell am I doing wrong

Thanks for the help in advance

David