Hi,
Check the following Code
SELECT GETDATE()
GO
SELECT CONVERT(VARCHAR(8),GETDATE(),108) AS HourMinuteSecond,
CONVERT(VARCHAR(10),GETDATE(),101) AS DateOnly;
GO
SELECT CONVERT(TIME,GETDATE()) AS HourMinuteSeconds;
SELECT CONVERT(DATE,GETDATE()) AS DateOnly;
GO
Check the link
Get Date and Time From Current DateTime [
^]
Regrds,
GVPrabu