Built-in Date functions

1. SYSDATETIME() - To returns the server’s date and time.
2. SYSDATETIMEOffset() - It returns the server’s date and time, along with UTC offset.
3. GETUTCDATE() - It returns date and GMT (Greenwich Mean Time ) time.
4. GETDATE() - It returns server date and time.