Find row which is inserted time
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
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Guest UserPosted Apr 12, 2011, 2:22 PM
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