Data Type for Time

What is the data type for time?

Example: 8:45 am

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


Recent Articles: