Datetiime column needs to show only the time

Question

I have a datetime column that has data as this:

Appt_DateTime  (datetime, not null)`
12/30/1899   7:50:00PM

I want to display only the time in this case the 7:50:pm. it can be with or without the seconds, better without them.

How can I do this in a select?

This was answered in: https://stackoverflow.com/questions/7710449/how-to-get-time-from-datetime-format-in-sql — Kyle Burns, Oct 18 '17 at 22:28

mhasan · Accepted Answer · 2017-10-19T17:11:50.537

0

You may try this by using something like

Select   cast(<your column name> as time) [time] from <your table>

edited Oct 19 '17 at 17:11

answered Oct 18 '17 at 22:31

mhasan

1 Answers1