MySQL time field format and encoding conversion, a temporary solution for saving time data in XML under C #

Because the XML string generated by calling the dataset built-in method getxml () in C # does not have the XMLSCHEMA Architecture
In the generated XML string, the time format is"2009-07-07t14: 58: 27 + 08: 00 "stored

If there is no comment on the XMLSCHEMA architecture during receiving end parsing
<Xs: Element Name="Dept_createtime"Type="Xs: datetime"Minoccurs="0"/>
XML data"2009-07-07t14: 58: 27 + 08: 00 "will be parsed by Default Characters

So in the project, my solution is to generate a specific string format when querying using SQL statements.

Convert (date_format (N. node_begin_time, '% Y. % C. % e') using utf8) as begin_time
// Use the date_format () function to format the style.
// Use the convert () function for encoding and conversion to generate the C # string encoding method. Otherwise, it will be displayed in the database and displayed in C # as a system. byte []

ReferenceArticle:
MySQL uses the date_format () function to convert the string to the time type and format the time.