sql query to get records for current date code example

Example: get current date sql

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