SQL command to get the current date is the day of the week code Summary

1 "select datepart (weekday, getdate ())

This is the integer of the returned day of the week!

2 "select datename (weekday, getdate ())

This is more convenient. You can directly return the day of the week type. For example, if today is Tuesday, enter Tuesday.

Note: If the obtained Date Field is short integer, for example, the week may be incorrect!

3 "select a as week, getdate () as date
From (select a = 'monday', B = 1
Union all select 'tuesday', 2 Union all select 'wedday', 3
Union all select 'thurs', 4 union all select 'Friday', 5
Union all select 'saturday', 6 Union all select 'sunday', 0
) A Where B = (datepart (weekday, getdate ()-1)

This methodCodeA little more, but the corresponding functions can also be achieved!