Data Type for Time

Question:
What is the data type for time?

Example: 8:45 am

Answer:
What you really have is the tail end of a datetime data type. You can get it back this way by asking for this:

select convert(char,getdate(),8)

Hope this helps.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: