SQL get newest date time code example

Example 1: sql server current date without time

SELECT CAST (GETDATE() AS DATE)

Example 2: get current date sql

SELECT getdate(); -- Get Current date in SQL Server