Blog
- August 3, 2008
- MS SQL WHERE, GROUP BY and ORDER BY on Datetime
I decided to implement login tracking for one of the personal applications I'm developing. Getting each users login time stamp into the database is the easy part, however building graphs and reports is a bit more difficult. This has to do with the way MS SQL stores dates, they always have a time stamp. If you don't specify one when you insert your date it will add 12:00:00 AM for you, so searching for dates like this is easy. However, my login tracking actually inserts the time of login as well.
Read More- Comments(0)