How Do I Display Month and Day from a dd-mon-yyyy String

Question

User564995064 posted

I have a date coming back from an Oracle database in dd-mon-yy format.  I need to display the date in a label as month dd.  For example:  12-MAR-18 would display as March 12.  How an I accomplish this?

            string deadline = late_app_date.Rows[0]["deadline"].ToString();   

            DateTime format_mmmdd = (Convert.ToDateTime(deadline.ToString()));

            String dd = format_mmmdd.Day.ToString();
            String mon = format_mmmdd.Month.ToString();
            String yy = format_mmmdd.Year.ToString();
            Session["deadline"] = mon + " " + dd;

The above code did not work.  The deadline string does display dd-mon-yy.

Thanks for any assistance you can give.

Answer 1

User409696431 posted

First, is the date coming in as a literal string, "12-MAR-18"?

If so, the code you have would yield a string "3 12", as you would expect since DateTime.Month and DateTime.Day are numbers.  Is that what you are getting?

If you want the month to be a full long month name, not a number, use

String mon = format_mmmdd.ToString("MMMM");

(Also, the .ToString() in the line  DateTime format_mmmdd = (Convert.ToDateTime(deadline.ToString()));  is unnecessary, since deadline is already a string.)

Answer 2

User-707554951 posted

Hi rhondadunn

Working code as below:

 DateTime to = DateTime.Parse("3/12/2018");

            string result = to.ToString("dd-MMM-yy");
            Response.Write(result+ "<br />");

            string format= Convert.ToDateTime(result).ToString("dd-MMMM-yy");
            string Finalresult = format.Split('-')[1] + " " + format.Split('-')[0];
            Response.Write(Finalresult);

Result:

Best regards

Cathy

Answer 3

User1623409651 posted

Hi,

string _Date = "01-19-2013";
            DateTime dt = Convert.ToDateTime(_Date);
         
            string FDate = dt.ToString("dd-MMM-yyyy");

Thanks

Answer 4

User516094431 posted

 string deadline = late_app_date.Rows[0]["deadline"].ToString();   

            DateTime format_mmmdd = (Convert.ToDateTime(deadline.ToString()));

AS per your requirement, you can use simple code:

string date = format_mmmdd.ToString("MMMM dd"));