DATE TIME convertion into AM/PM

Sagar Pallavi

Hi Team,

Good Morning. I am getting datetime field from database and we are converting that to string i.e 2021-10-20 23:00 by taking year, date and month part. Now I want to display as 2021-10-20 11:00 PM.

could you please suggest.

Thanks in advance.

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar4y ago
Accepted answer
Hi Sagar Pallave,

Please refer this article which will help you out,
https://www.c-sharpcorner.com/UploadFile/70dbe6/string-was-not-recognized-as-a-valid-datetime-error-and-thei/
+2
Sachin Singh4y ago
another one
var formattedDate=string.Format("{0:hh:mm:ss tt}", Convert.ToDateTime(yrDate)) ;
+3
Asha Anand4y ago
SAP Faculty
0
Satya Karki4y ago
Examples:
select convert(varchar(20),GETDATE(),1)+' '+convert(varchar(20),convert(time,getdate()),100);
select convert(varchar(20),GETDATE(),103)+' '+convert(varchar(20),convert(time,getdate()),100)
select convert(varchar(20),GETDATE(),103)+' '+convert(varchar(20),convert(time,getdate()),22);


    > Result (1) :-  10/15/2018 11:22AM (mm/dd/yyyy hh:mm AM/PM)
    > Result (2):-  15/10/2018 11:22AM (dd/mm/yyyy hh:mm AM/PM)
    > Result (3):-  15/10/2018 11:22:35 AM (dd/mm/yyyy hh:mm:ss AM/PM)
+1
Rijwan Ansari4y ago
You can modify in select query as shown sample
Select FORMAT(EntryDate,'MM/dd/yyyy hh:mm:s tt')
From DB1
result: 09/26/2014 11:04:54 AM
+3
Srinivasan Ramamoorthi4y ago
Use this for c# Convert.ToDateTime(dateTime).ToString("yyyy-MM-dd h:mm tt");
+3
Asma Khalid4y ago
In C# use below code i.e.
DateTime myDatetime = DateTime.Now;
string myFormattedDatetime = myDatetime.ToString("yyyy-MM-dd hh:mm tt");

Mark answer as accepted if helpful

Thanks & Regards,
Asma Khalid

For More Visit: www.asmak9.com or www.bytezaar.com
+3
Yogesh Ghorpade4y ago
Select FORMAT(GETDATE(),'yyyy-MM-dd hh:mm:s tt')
+1
Yogesh Ghorpade4y ago
Use This Function

Select FORMAT(GETDATE(),'yyyy/MM/dd hh:mm:s tt')
+1