I have a table record and have two fields definitions namely:
- TotalActivity datatype DateTime on SQL query,
- LastActivity datatype decimal
My problem is how do I calculate these on that record? I have tried to use this data format. How do I use this on my query for that record?
SELECT REPLACE(convert(varchar,getdate(),100),year(getdate()),'at') SELECT substring(convert(varchar,getdate(),114),0,8)