תשובות:
1)
SELECT GetDate()
2) ניתן להשתמש ב DatePart, אבל צריך להתחשב בערך של DATEFIRST@@. מתוך ה BOL:
@@DATEFIRST Returns the current value of the SET DATEFIRST parameter, which indicates the specified first day of each week: 1 for Monday, 2 for Wednesday, and so on through 7 for Sunday. SELECT @@DATEFIRST AS 'First day of the week', DatePart(dw, GetDate()) As 'Today'