Check out example codes for "name of today sql". It will help you in understanding the concepts better.

Code Example 1

SELECT GETDATE() 'Today', DATENAME(weekday,GETDATE()) 'Day Name'
SELECT GetDate() 'Today', DATENAME(dw,GETDATE()) 'Day Name'

Learn ReactJs, React Native from akashmittal.com