Show (Display) Time in Hour and Minutes with AM PM format in SQL Server

rakibxl

SOLVED CLOSED ACTIVE ANSWERED
User: rakibxl
Posted: on Apr 02, 2020 09:42 AM
Forum: SQL Server
Answer: 1
Views: 5967

How to show Hour and minutes with AM PM in SQL Server

I want to show like 03:34 PM or 03:34 AM my above query doing that but the problem is from database it is not showing exact time. in the table Column Start Date has value 3: 45 pm but showing 4:45 PM

SELECT FORMAT(getdate(), 'hh:mm tt') AS CarrierDeliveryStartDateHour

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 1

Reply
ANSWER
User: Mudassar
Replied: on Apr 02, 2020 09:43 AM
Report

Refer:

Convert DateTime to dd-MMM-yyyy hh:mm format in SQL Server

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Show (Display) Time in Hour and Minutes with AM PM format in SQL Server

Company

Explore

Follow us

Contact Us