Check this link:
Date Formats Sql Server[
^]
If you want only Date or time, u can use
convert[
^] or Cast
Select CONVERT(VARCHAR(5),GetDate(),114) [Time HH:MM],Cast(Getdate() as Time) [Time]
Select CONVERT(VARCHAR(10), GETDATE(), 102) [Date YYYY.MM.DD],Cast(GetDate() as Date) [Date YYYY-MM-DD]
But Convert is Recommended...