DATE TIME convertion into AM/PM

Question

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.

Jignesh Kumar · 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/

Sachin Singh · Answer

another one var formattedDate=string.Format( "{0:hh:mm:ss tt}" , Convert.ToDateTime(yrDate)) ;

Rijwan Ansari · Answer

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

Srinivasan Ramamoorthi · Answer

Use this for c# Convert.ToDateTime(dateTime).ToString("yyyy-MM-dd h:mm tt");

Asma Khalid · Answer

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

Satya Karki · Answer

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)

Yogesh Ghorpade · Answer

Select FORMAT(GETDATE(),'yyyy-MM-dd hh:mm:s tt')

Yogesh Ghorpade · Answer

Use This Function Select FORMAT(GETDATE(),'yyyy/MM/dd hh:mm:s tt')

Asha Anand · Answer

SAP Faculty