Get Date/Time from datetime datatype SQL SERVER

To get DatePart of DateTime type

SELECT CONVERT(DATE,GETDATE()) AS DateOnly

To get Time part in

SELECT CONVERT(TIME,GETDATE()) AS HourMinuteSeconds;
SELECT convert(varchar(8),GETDATE(), 108)