How to convert datetime HH:DD:SS AM/PM to HH:DD AM/PM

asp.net datetime oracle10g datetime-format to-char
RMN picture RMN · Mar 1, 2012 · Viewed 14.1k times · Source

I have a gridview column, where I need to display time in format : 3/2/2012 1:22 PM

but my Db saves as 3/2/2012 1:22:42 PM

I want to remove seconds from this text. I can remove it using (MM/DD/YYYY HH:MM:SS) but how do i include the AM/PM from db column ?

Answer

Andre Loker picture Andre Loker · Mar 1, 2012

If the database provides the date as a DateTime, try to set the DataFormatString property of the GridView column to match your needs. For example

{0:MM/dd/yyyy hh:mm tt}

prints the column like 03/01/2012 03:09 PM .

Related questions

ASP.NET DateTime Picker

is there any good free/open source time picker control that goes well with ASP.NET Calendar control?

Read More
DateTime.TryParse issue with dates of yyyy-dd-MM format

I have the following date in string format "2011-29-01 12:00 am" . Now I am trying to convert that to datetime format with the following code: DateTime.TryParse(dateTime, out dt); But I am alwayws getting dt as {1/1/0001 12:00:00 AM} , Can you …

Read More
How to pass a datetime parameter?

How to pass UTC dates to Web API? Passing 2010-01-01 works fine, but when I pass a UTC date such as 2014-12-31T22:00:00.000Z (with a time component), I get a HTTP 404 response. So http://domain/api/controller/…

Read More