SELECT * FROM dbo.MaTable Where MaDate >= '09/08/2013 00:00:00' Order By MaDate; SELECT * FROM dbo.MaTable Where MaDate < < GETDATE() Order By MaDate; SELECT * FROM dbo.MaTable Where MaDate between '28/10/2005 09:10:00' and '28/10/2005 17:25:00' Order By MaDate;