I need some help, i have these two fields and want to filter their data types, but need some help as to how to work this out in sql server. Meaning TotalActivity must this format as output and LastActivity.
- Oct 13 at 3:41am
- 21:02:04 // Must always counts when a user logs in and out