mysql指定时间转换成yyyy-mm-dd,将C＃中的DateTime转换为yyyy-MM-dd格式并将其存储到MySql DateTime字段中...

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.

解决方案

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