Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Convert DateTime in C# to yyyy-MM-dd format and Store it to MySql DateTime Field

I am trying to convert DateTime format to yyyy-MM-dd format and store it to DateTime object. But it gives me the System DateTime format that is MM/dd/yyyy.
I am using following code to convert.

string dateTime = DateTime.Now.ToString();
string createddate = Convert.ToDateTime(dateTime).ToString("yyyy-MM-dd h:mm tt");         
DateTime dt = DateTime.ParseExact(createddate, "yyyy-MM-dd h:mm tt",CultureInfo.InvariantCulture);

but non of the above line converts into the specified format.
Can any one help to solve this.

I am getting the DateTime from one application and passing this object to other application and That application is storing that date into MySql's DateTime field which is in the format "yyyy-MM-dd".
This is why I have posted this question.

Project 1 has class from that I am getting the date. and the processor class which is the middle ware of the application it processes the DateTime format to convert in specific format. And passes to the Other project which consumes the DateTime and stores that in the MySql field.

like image 326
Rahul Gokani Avatar asked Oct 10 '13 12:10

Rahul Gokani


People also ask

How do I convert DateTime to date?

To convert a datetime to a date, you can use the CONVERT() , TRY_CONVERT() , or CAST() function.

What is ParseExact C#?

ParseExact(String, String, IFormatProvider) Converts the specified string representation of a date and time to its DateTime equivalent using the specified format and culture-specific format information. The format of the string representation must match the specified format exactly.


3 Answers

Use DateTime.Now.ToString("yyyy-MM-dd h:mm tt");. See this.

like image 153
Alex Avatar answered Sep 17 '22 05:09

Alex


We can use the below its very simple.

Date.ToString("yyyy-MM-dd"); 
like image 40
sanjay.arora29 Avatar answered Sep 20 '22 05:09

sanjay.arora29


Have you tried?

var isoDateTimeFormat = CultureInfo.InvariantCulture.DateTimeFormat;

// "2013-10-10T22:10:00"
 dateValue.ToString(isoDateTimeFormat.SortableDateTimePattern); 

// "2013-10-10 22:10:00Z"    
dateValue.ToString(isoDateTimeFormat.UniversalSortableDateTimePattern)

Also try using parameters when you store the c# datetime value in the mySql database, this might help.

like image 33
DrewbieDoo Avatar answered Sep 21 '22 05:09

DrewbieDoo