如何在XML中以int格式转换日期 [英] How to translate date in int format in XML

问题描述

我正在尝试将XML数据解析为数组，但问题是日期是如下所示的int类型。

I am trying to parse an XML data to an array but the problem is the date is a int type like below.

<xml xmlns:s='uuid:RTYUI1-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid:DFR12345-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:schemas-microsoft-com:rowset'
xmlns:z='#RowsetSchema'>
<s:Schema id='RowsetSchema'>
<s:ElementType name='row' content='eltOnly'>
    <s:AttributeType name='AdmissionDate' rs:number='1' rs:nullable='true' rs:maydefer='true' rs:writeunknown='true'>
        <s:datatype dt:type='int' dt:maxLength='4' rs:precision='10' rs:fixedlength='true'/>
    </s:AttributeType>
 <s:extends type='rs:rowbase'/>
</s:ElementType>
</s:Schema>
<rs:data>
 <z:row AdmissionDate='42569'/>
 </rs:data>

我正在使用xmlPasser.class从这里开始的.php类，其输出如下：

I am using xmlPasser.class.php class from here and i t outputs like below:

  [rs:data] => Array
            (
                [z:row] => Array
                    (
                        [0] => Array
                            (
                            )

                        [1] => Array
                            (
                            )

                        [0_attr] => Array
                            (
                                [AdmissionDate] => 42569

                            )

               ...

推荐答案

Excel将日期保存为1900年1月1日之后的天数

Excel save dates as amount of days after 1 jan 1900 year

$days = 42569;
$d = new DateTime('1900-01-01');
echo $d->modify("+$days day")->format('r'); // Wed, 20 Jul 2016 00:00:00 +0000

这篇关于如何在XML中以int格式转换日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！