how to change string date to datetime

Question

5.00/5 (1 vote)

See more:

hi friends!

i fetched date from database. in the database date is store as text(string) now i want to use this text and only take day and month from this text.

database date like this "24/12/2013"

now want only month and day from it how can i do i c#?

i used many things like below :

C#

Thread.CurrentThread.CurrentCulture = new CultureInfo("en-GB")ds1.Ta;
DateTime datadate = new DateTime(Convert.ToInt32(bles[0].Rows[0]"birthdate"].ToString().Substring(2, 2)));

2.

C#

DateTime datadate = new DateTime(Convert.ToDateTime(ds1.Tables[0].Rows[0]["birthdate"].ToString(), "MM/DD/YY HH:MM:SS TT", System.Globalization.CultureInfo.CurrentUICulture.DateTimeFormat);

3.

C#

 string bdate = ds1.Tables[0].Rows[0]["birthdate"].ToString();
DateTime dt = Convert.ToDateTime(bdate);

and used more method to do it but not succeed!

plz help me!

Posted 23-Dec-13 22:31pm

Gaurav Makwana

Updated 24-Dec-13 1:14am

Tejas Vaishnav

v4

Add a Solution

Comments

Richard MacCutchan 24-Dec-13 4:37am

It is very bad practice to store dates as text, use a proper Date or DateTime field.

Gaurav Makwana 24-Dec-13 4:47am

sorry sir but you know sometime its needed just think about it!

Richard MacCutchan 24-Dec-13 4:59am

I have thought about and it is never needed. Everyone who does this runs into trouble sooner or later. Look at the code you have shown above, you have to convert a value to a string in order to convert it back to a value. How much wasted code and time is that adding to your application?

Gaurav Makwana 24-Dec-13 5:30am

thnk you

8 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

JoCodes · Answer 1 · 2013-12-23T22:51:00

Solution 2

TRY

DateTime.ParseExact(dateString, MMMM dd", System.Globalization.CultureInfo.InvariantCulture);

Posted 23-Dec-13 22:51pm

JoCodes

Updated 23-Dec-13 22:56pm

v2

Comments

Gaurav Makwana 24-Dec-13 5:28am

thank you sir

JoCodes 24-Dec-13 9:15am

Welcome :)

Karthik_Mahalingam · Answer 2 · 2013-12-23T23:24:00

Solution 4

HI Try this..

C#

var datetime = DateTime.ParseExact("24/12/2013", "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
    string month  = datetime.ToString("MM"); // 12
      string day  = datetime.ToString("dd"); //24

Posted 23-Dec-13 23:24pm

Karthik_Mahalingam

TrushnaK · Answer 3 · 2013-12-23T23:56:00

Solution 5

try this and modify textbox.text with your dataset:-

C#

string strDay = Convert.ToDateTime(txtDt.Text).ToString("dd");
 string Month = Convert.ToDateTime(txtDt.Text).ToString("MM");

Posted 23-Dec-13 23:56pm

TrushnaK

Nick Fisher (Consultant) · Answer 4 · 2013-12-24T00:44:00

Solution 7

C#

String MMdd = DateTime.ParseExact("24/12/2013", "dd/MM/yyyy", null).ToString("MMdd");

Posted 24-Dec-13 0:44am

Nick Fisher (Consultant)

v2

Rakesh Meel · Answer 5 · 2013-12-24T00:46:00

Solution 8

visit here....

Conversion of string to date time in c# asp.net[^]

Posted 24-Dec-13 0:46am

Rakesh Meel

Ganesh Raja · Answer 6 · 2013-12-23T22:36:00

Solution 1

Use convert or parse to get the required output.

C#

DateTime.Parse(inputDate.Value).ToString("dd-MM-yyyy");

Posted 23-Dec-13 22:36pm

Ganesh Raja

Comments

Gaurav Makwana 24-Dec-13 4:47am

it is not working sir!

Ganesh Raja 24-Dec-13 4:51am

Can u pls check the below..and its working.
string temp = DateTime.Parse("24/12/2013").ToString("dd-MM");

Gaurav Makwana 24-Dec-13 5:30am

thank you but it is also not working ganesh sir
its says date in not in valid datetime date

Tejas Vaishnav · Answer 7 · 2013-12-23T22:55:00

Add this function to your code

C#

private DateTime ParseDate(string input)
        {
            //Date formats, if your date is not in this format then please adds that 
            //custom format to this array, so it will convert your string to appropriate date
            // like 24-Dec-2013 is my string of date and it’s in dd-MMM-yyyy format and it’s not in current 
            //listed format then I just need to add dd-MMM-yyyy to below format lists, in the same way 
            //you need to add your fomat to this list to get sucessfully convertion of string to datetime

            string[] formats = new string[] { "MM/dd/yyyy"
                    , "MM/dd/yyyy HH:mm:ss tt"
                    , "MM/dd/yyyy HH:mm:ss"
                    , "dd/MM/yyyy"
                    , "dd/MM/yyyy HH:mm:ss tt"
                    , "dd/MM/yyyy hh:mm:ss"
                    , "dd/MM/yyyy hh:mm:ss tt"
                    , "dd/MM/yyyy HH:mm:ss" };

            DateTime result = default(DateTime);
            DateTime.TryParseExact(input, formats, CultureInfo.InvariantCulture, DateTimeStyles.None, out result);
            
            return result;
        }

and use this function like this..

C#

DateTime BirthDateTime = ParseDate("25/06/1988");
           int BirhtMonth = BirthDateTime.Month;
           int BirhtDay = BirthDateTime.Day;

in your case you need to pass like this..

C#

DateTime BirthDateTime = ParseDate(ds1.Tables[0].Rows[0]["birthdate"].ToString());
            int BirhtMonth = BirthDateTime.Month;
            int BirhtDay = BirthDateTime.Day;

ErBhati · Answer 8 · 2013-12-24T00:13:00

Solution 6

you can use this

C#

string strDay = Convert.ToDateTime(txtDt.Text).ToString("dd");
 string Month = Convert.ToDateTime(txtDt.Text).ToString("MM");

Posted 24-Dec-13 0:13am

ErBhati

Comments

TrushnaK 24-Dec-13 6:16am

what you have done copy- paste
at least change variable name and textbox name...

how to change string date to datetime

8 solutions

Solution 2

Solution 4

Solution 5

Solution 7

Solution 8

Solution 1

Solution 3

Solution 6

Add your solution here

Preview 0

Existing Members

...or Join us