Home / Software / Tips and Tricks / How to select time from sql server in AM - PM Format (Meridiem)?

How to select time from sql server in AM - PM Format (Meridiem)?

Updated:  02/23/2012 09:02 AM
Author:  Shiju Mathews

Status:    Resolved.


Using substring and convert function we can genarate time in AM / PM Format. There is no single function in sql to perform this.



Output : 11:55 AM