How to change date format in asp.net

Question

how to change the date time format 2011-09-01 09:39:23 to 2011-Aug-01 09:39:23 in asp.net

I am using this DateTime.Now; to get the date time but I want it in 2011-Aug-01 09:39:23 format, how to do that

I set datetime as string now = DateTime.Now.ToString("dd-MMM-yyyy hh:mm:ss");

both did not work

 param[1] = new MySqlParameter("@Created", MySqlDbType.DateTime);
        param[1].Value = now;
        command.Parameters.AddWithValue("@Created", now);
        param[2] = new MySqlParameter("@Modified", MySqlDbType.DateTime);
        param[2].Value = DateTime.Now.ToString("dd-MMM-yyyy hh:mm:ss"); 
        command.Parameters.AddWithValue("@Modified", DateTime.Now.ToString("dd-MMM-yyyy hh:mm:ss"));

Kevek · Accepted Answer · 2011-09-07 00:12:19Z

4

You will find This article useful

More specifically, you want:

yourDate.toString("yyyy-MMM-dd hh:mm:ss");

answered Sep 7, 2011 at 0:12

Kevek

2,5645 gold badges18 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rob · Accepted Answer · 2011-09-07 00:13:39Z

2

DateTime.Now.ToString("yyyy-MMM-dd hh:mm:ss");

answered Sep 7, 2011 at 0:13

Rob

10.3k5 gold badges64 silver badges93 bronze badges

Comments

Jake1164 · Accepted Answer · 2012-08-27 12:04:59Z

2

if (IsPostBack)
{
    txtrcptdate.Text = DateTime.Now.ToString("dd/MMM/yyyy hh:mm:ss ");
}

edited Aug 27, 2012 at 12:04

Jake1164

12.4k6 gold badges49 silver badges65 bronze badges

answered Aug 27, 2012 at 11:04

sathiyan

211 bronze badge

Collectives™ on Stack Overflow

How to change date format in asp.net

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related