如何在xml中将datetime转换为date [英] How to convert datetime to date in xml
本文介绍了如何在xml中将datetime转换为date的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
亲爱的所有人,
我正在编写代码将数据集数据转换为XML文件,但日期未格式化为dd / mm / yyyy这个我的代码:
string SQL = SELECT ID,sDate,来自tbl_Contact的LName;
SqlConnection cn = new SqlConnect(Connect.ConnectME());
cn.open();
DataSet ds = new DataSet();
Sqlcommand cmd = new Sqlcommand(SQL);
SqlDataAdapter AD = new SqlDataAdapter(cmd);
// AD.SelectCommand = cmd;
AD.Fill(ds) ;
ds.Tables [ 0 ]。Tablename = ART_Record跨度>;
ds.WriteXml( @ C:\ EMR_INTERFACE \ARTAdherence.xml) ;
当我运行此代码时,我的XML文件看起来像这样
< art_record >
< art_record >
< patientid > 00001 < / patientid >
< patienteverstartedonart > ART < / patienteverst artedonart >
< art_start_date > 2010-05-25T00:00:00 + 01:00 < / art_start_date >
< last_drug_pickup_date > 2015-08-11T00:00:00 + 01:00 < / last_drug_pickup_date >
< span class =code-keyword>< facilityid > 1000 < / facilityid >
< span class =code-keyword>< / art_record >
日期应该像25/5/2010
我的尝试:
请告诉我如何纠正日期。
谢谢大家
解决方案
最简单的方法是在从中检索时格式化它SQL:
string SQL = SELECT ID,CONVERT(NVARCHAR(10),sDate,103),来自tbl_Contact的LName;
< blockquote>据我所知,XML DateTime格式是标准化的,日期格式为YYYY-MM-DD。
XML模式日期/时间数据类型 [ ^ ]
为什么在XML中需要另一种日期格式?
Dear All,
I am writing code to convert dataset data's to XML file, but the date is not formatted as "dd/mm/yyyy" this my code:
string SQL = "SELECT ID,sDate,LName from tbl_Contact";
SqlConnection cn =new SqlConnect(Connect.ConnectME());
cn.open();
DataSet ds = new DataSet();
Sqlcommand cmd = new Sqlcommand(SQL);
SqlDataAdapter AD = new SqlDataAdapter(cmd);
//AD.SelectCommand = cmd;
AD.Fill(ds);
ds.Tables[0].Tablename="ART_Record";
ds.WriteXml(@"C:\EMR_INTERFACE\ARTAdherence.xml");
When i ran this code my XML file look like this
<art_record>
<art_record>
<patientid>00001</patientid>
<patienteverstartedonart>ART</patienteverstartedonart>
<art_start_date>2010-05-25T00:00:00+01:00</art_start_date>
<last_drug_pickup_date>2015-08-11T00:00:00+01:00</last_drug_pickup_date>
<facilityid>1000</facilityid>
</art_record>
the Date should be like 25/5/2010
What I have tried:
kindly show me how to correct the date.
thank you all
解决方案
Easiest way is to format it when you retrieve it from SQL:
string SQL = "SELECT ID,CONVERT(NVARCHAR(10), sDate, 103),LName from tbl_Contact";
As far as I understand, XML DateTime format is normalized with date being formatted as "YYYY-MM-DD".
XML Schema Date/Time Datatypes[^]
Why do you need another date format in XML ?
这篇关于如何在xml中将datetime转换为date的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文