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

home / software / tips and tricks / 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

alt="Add your business to our listing Free"