Get Time In AM/PM Format In SQL Server 2008

This article explains how to get time in AM/PM Format.
  • 3320

Introduction

This article explains how to get time in AM/PM Format.

Sometimes you want to display AM/PM time format. There is no option in standard Convert format to return AM/PM format.

I tried with different way and come up with the simple solution. Write following query to return only the time portion of the current date/time in an AM/PM format.

Execute the code and you will get time in AM/PM format.

DateFormatInAMandPM.jpg

© 2020 DotNetHeaven. All rights reserved.