how get only date and time in sql code example

Example: sql getdate date only

-- MS SQL Server
SELECT CAST(getdate() AS date);
SELECT CAST(getdate() AS varchar(10));