Get Date time SQL | Time | date | SQL server queries | DateTime functions in SQL Server 

This video contains the various date time functions in SQL/ SQL server. There is also an explanation for getting an only date, only time, or a combination of both and different styles and formats.
Get Date time SQL | Time | date | SQL server queries | DateTime functions in SQL Server