I've found that there is a function called "trftime" in Sqlite. However, I cannot find any function like this in T-SQL. Is there any function to do this?
Like this? I don't know SQLLite.
select datepart(dw, getdate())
SELECT (DATEDIFF(dd,'17530101',GETDATE())-1) %7