比较sql date和javascript date [英] compare sql date to javascript date

问题描述

是否有一种简单的方法可以将sql dateTime和javascript datetime进行比较，以便可以轻松比较两者?

Is there an easy way to compare a sql dateTime to a javascript date time so that the two can be compared easily?

有内置的javascript函数，因为我无法编辑sql

Are there built in javascript functions as I cant edit the sql

推荐答案

要将MySQL DATETIME字符串转换为JavaScript Date对象:

To convert a MySQL DATETIME String into a JavaScript Date object:

        var sqlDateStr = "2012-01-02 23:58:59"; // as for MySQL DATETIME
        sqlDateStr = sqlDateStr.replace(/:| /g,"-");
        var YMDhms = sqlDateStr.split("-");
        var sqlDate = new Date();
        sqlDate.setFullYear(parseInt(YMDhms[0]), parseInt(YMDhms[1])-1,
                                                 parseInt(YMDhms[2]));
        sqlDate.setHours(parseInt(YMDhms[3]), parseInt(YMDhms[4]), 
                                              parseInt(YMDhms[5]), 0/*msValue*/);
        alert(sqlDate);

这篇关于比较sql date和javascript date的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！