get date from sql datetime code example

Example 1: sql display today's date

SELECT getdate()

Example 2: convertir datetime a date

declare @fecha datetime 

set @fecha = GETDATE()

select convert(date ,@fecha)