title: SQL: Trigger set column to null
body: <p>I created a trigger to set a column to null where the column has a value greater than <code>GETDATE()</code> </p>
  
  <pre><code>ALTER TRIGGER [dbo].[Null_Time_Trigger3]
  
    on [dbo].[Parking]
    FOR insert
    as
    update Parking
    set Column = NULL
    from Parking
    where Column &gt;= CAST(GETDATE () AS TIME)
  </code></pre>
  
  <p>it appears when the time passes the trigger doesn't do anything? the time is still in the column and the column is not having the value of <code>NULL</code>.</p>
  
  <p>Any idea how to resolve this ??</p>
  
  <p>Is there anyway to do this <code>(Setting the column to null) other than triggers???</code></p>
  
  <p>Regards. </p>