Home / Software / Tips and Tricks / How can I format the time in AM-PM format (MeridiemTime Format)?

How can I format the time in AM-PM format (MeridiemTime Format)?

Updated:  04/17/2012 12:04 PM
Author:  Shiju Mathews

Status:    Resolved.


By using the built in function 'CONVERT', make a string then substring it using 'left' and 'Right' function



Result: 3:48 PM