-- Get all dates that have passed SELECT DateTimeValue FROM YourTable WHERE DateTimeValue < GetDate()