Find row which is inserted time

Question

Hello everybody. I have a database which is inserted by time .I want to get a row which is inserted by older time. What is command in SQL?Thanks

John Penn · Answer

use a WHERE clause to filter the records as in these examples: WHERE my_datetime > 'your desired date/time here' WHERE my_datetime BETWEEN 'your_minimum_datetime' AND 'your_maximum_datetime' more details at http://msdn.microsoft.com/en-us/library/ms188047.aspx