日期转换 .NET JSON 到 ISO

2022-01-11 00:00:00 python datetime javascript json.net

如何从 JSON.Net 转换日期时间格式，例如:

How can I convert a date time format from JSON.Net such as:

/日期(1154970000000+0700)/

/Date(1154970000000+0700)/

到 ISO-??格式2011-12-18T23:34:59Z

To ISO-?? format 2011-12-18T23:34:59Z

最好使用 Python 或 Javascript.

Preferably in either Python or Javascript.

我决定选择后者，因为它在 JS 世界中似乎是使用最广泛、可读性最强且自然可排序的.我将按用户存储偏移量.

Ive decided on the latter as its seems in the JS world the most widely used, humanly readable and naturally sortable. I'll store offsets on a per user basis.

如果一个实现有点太问了，如果有人能告诉我这两种格式的正确名称，我可能会更幸运地理解如何转换.

If an implementation is again a bit much too ask, if someone can tell me the correct name for both formats I might have more luck in understanding how to convert.

推荐答案

jsonDate = "/Date(1154970000000+0700)/";

var strDate = parseInt(jsonDate.replace(//Date(([-d]+).*$/, "$1"));
var strHour = parseInt(jsonDate.replace(/.*d([+-]dd).*$/, "$1"), 10);
var strMin = parseInt(jsonDate.replace(/.*d([+-])dd(dd).*$/, "$1$2"), 10);

var date = new Date(strDate);
if (!isNaN(strHour)) date.setHours(date.getHours() + strHour);
if (!isNaN(strMin)) date.setMinutes(date.getMinutes() + strMin);

var out = date.toISOString();

以及转换为 ISO 的函数:

And the function to convert to ISO:

var toISOString = Date.prototype.toISOString ?
    function(d){return d}:
    (function(){
        function t(i){return i<10?"0"+i:i};
        function h(i){return i.length<2?"00"+i:i.length<3?"0"+i:3<i.length?Math.round(i/Math.pow(10,i.length-3)):i};
        function toISOString(){
            return "".concat(
                this.getUTCFullYear(), "-",
                t(this.getUTCMonth() + 1), "-",
                t(this.getUTCDate()), "T",
                t(this.getUTCHours()), ":",
                t(this.getUTCMinutes()), ":",
                t(this.getUTCSeconds()), ".",
                h("" + this.getUTCMilliseconds()), "Z"
            );
        };
        return function(d){
            d.toISOString = toISOString;
            return d;
        }
    })();

相关文章