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
Tags: How to select time from sql server in AM - PM Format (Meridiem)?
Updated on: October 2024