cheryl9063
asked on
SQL Format Time
I have a datetime field in SQL that I need to convert to
HH:MM AM/PM
Concatenation is fine.
How?
ASKER
When I put getdate() in place of yourfield.. I get the below..
11 4:15PM
11 4:15PM
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
select right( convert(varchar(30), yourfield, 0), 10)