How I can retrieve 'WEEKDAY' part by passing 'ddd' format in SQL Server?

For example in if I pass 'tue' and the response will be 3, beacuse

1 - Sunday
2 - Monday
3 - Tuesday

... like that.

I get the 'WEEKDAY' of current date by executing following query. 

```
select DATEPART(WEEKDAY, GETDATE())

```