datetime is stored properly...
when you want to fetch & display just set format in select statement
for display time in
hh:mm:ss tt format...
use this
select
convert(varchar,datepart(hh,getdate()) % 12) + ':' + convert(varchar,datepart(Mi,getdate())) +':' +
convert(varchar,datepart(ss,getdate())) + ' ' +
CASE WHEN DATEPART(HH,getdate()) < 13 THEN 'AM' ELSE 'PM' END
Replace
Getdate() with your columnname
Happy Coding!
:)