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
Tags: How can I format the time in AM-PM format (MeridiemTime Format)?
Updated on: April 2024