smalldatetime comparison SQL Server
<p>I have a <em>smalldatetime</em> field in my SQL database. The SQL format for this is type is : yyyy-mm-dd hh:mm:ss</p>

<p>I need to query my database and request all records where the date matches today's date AND the time portion is 100 minutes from the present time.</p>

<p>Help with the SQL would be greatly appreciated.</p>

<p>Thank you.</p>