Hi,
I have stored the users login details in a table.. But i wnt to show only todays login details.. How do i do it? All users who logged in only today should be displayed in the data control... Plzz help me how do i do it..
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.
Posted Jun 29, 2011, 12:03 AM
If so then, select * from LoginDetailsTable where convert(varchar(10),LoginDate,103) = convert(varchar(10),getdate(),103)
This will return you , today logged in today.
Hope this helps you.