Comparing datetime values in MS SQL
<p>This question might be a duplicate but I’ve tried all the answers of the other questions and none of the answers did help.</p>

<p>I'm trying to compare a datetime value against a static one ( I need every record with a date lager then 1/1/2016 )</p>

<pre><code>CREATE PROCEDURE Cursusoverzicht as
SELECT tblBijeenkomst.bijeenkomstdatum, tblCursussen.cursus_id, tblCursussen.cursustitel
FROM tblCursussen
INNER JOIN [dbo].[tblCursusDocenten] on [dbo].[tblCursusDocenten].[cursus_id] = [dbo].[tblCursussen].[cursus_id]
INNER JOIN [dbo].[tblBijeenkomst] on [dbo].[tblBijeenkomst].[docent_id] = [dbo].[tblCursusDocenten].[docent_id]
WHERE tblBijeenkomst.bijeenkomstdatum &gt; '2016/1/1 00:00:00:000'
</code></pre>

<p>This keeps returning 0 records, anyone any idea?</p>

<p>Sorry for the dutch names</p>