how to get cuurent date data in sql code example

Example: sql display today's date

SELECT getdate()