//当前时间戳time(); //当前时间格式date("Y-m-d H:i:s",time());//昨天时间格式date("Y-m-d,H:i:s",time()-3600*24);
//将日期格式转为时间戳strtotime("now"); //当前时间戳strtotime("last Monday"); //上个星期一的时间戳strtotime(" 1 day"); //一天后的时间戳strtotime("2018-09-27"); //1537977600
js中时间操作单位是毫秒
var timestamp1 = Date.parse(new Date());var timestamp2 = (new Date()).valueOf();var timestamp3 = new Date().getTime();
第一种:获取的时间戳是把毫秒改成000显示,第二种和第三种是获取了当前毫秒的时间戳。
var oldTime = (new Date("2018-09-27 08:00:20")).getTime();getTime()返回数值的单位是毫秒。
function getLocalTime(nS) { return new Date(parseInt(nS)).toLocaleString().replace(/:\d{1,2}$/,'');}
parseInt()
函数可解析一个字符串,并返回一个整数
toLocaleString()
方法可根据本地时间把 Date 对象转换为字符串,并返回结果。
replace(/:\d{1,2}$/,'')
验证替换以:开始有一位或二位数字的结束字符串,就是秒;替换为空
function add0(m){return m<10?'0' m:m }function format(shijianchuo){ //shijianchuo是整数,否则要parseInt转换 var time = new Date(shijianchuo); var y = time.getFullYear(); var m = time.getMonth() 1; var d = time.getDate(); var h = time.getHours(); var mm = time.getMinutes(); var s = time.getSeconds(); return y '-' add0(m) '-' add0(d) ' ' add0(h) ':' add0(mm) ':' add0(s);}
/*** 和PHP一样的时间戳格式化函数* @param {string} format 格式* @param {int} timestamp 要格式化的时间 默认为当前时间* @return {string} 格式化的时间字符串*/function date(format, timestamp){ var a, jsdate=((timestamp) ? new Date(timestamp*1000) : new Date()); var pad = function(n, c){ if((n = n "").length < c){ return new Array( c - n.length).join("0") n; } else { return n; } }; var txt_weekdays = ["Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday"]; var txt_ordin = {1:"st", 2:"nd", 3:"rd", 21:"st", 22:"nd", 23:"rd", 31:"st"}; var txt_months = ["", "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"]; var f = { // Day d: function(){return pad(f.j(), 2)}, D: function(){return f.l().substr(0,3)}, j: function(){return jsdate.getDate()}, l: function(){return txt_weekdays[f.w()]}, N: function(){return f.w() 1}, S: function(){return txt_ordin[f.j()] ? txt_ordin[f.j()] : 'th'}, w: function(){return jsdate.getDay()}, z: function(){return (jsdate - new Date(jsdate.getFullYear() "/1/1")) / 864e5 >> 0}, // Week W: function(){ var a = f.z(), b = 364 f.L() - a; var nd2, nd = (new Date(jsdate.getFullYear() "/1/1").getDay() || 7) - 1; if(b <= 2 && ((jsdate.getDay() || 7) - 1) <= 2 - b){ return 1; } else{ if(a <= 2 && nd >= 4 && a >= (6 - nd)){ nd2 = new Date(jsdate.getFullYear() - 1 "/12/31"); return date("W", Math.round(nd2.getTime()/1000)); } else{ return (1 (nd <= 3 ? ((a nd) / 7) : (a - (7 - nd)) / 7) >> 0); } } }, // Month F: function(){return txt_months[f.n()]}, m: function(){return pad(f.n(), 2)}, M: function(){return f.F().substr(0,3)}, n: function(){return jsdate.getMonth() 1}, t: function(){ var n; if( (n = jsdate.getMonth() 1) == 2 ){ return 28 f.L(); } else{ if( n & 1 && n < 8 || !(n & 1) && n > 7 ){ return 31; } else{ return 30; } } },// YearL: function(){var y = f.Y();return (!(y & 3) && (y % 1e2 || !(y % 4e2))) ? 1 : 0},//o not supported yetY: function(){return jsdate.getFullYear()},y: function(){return (jsdate.getFullYear() "").slice(2)},// Timea: function(){return jsdate.getHours() > 11 ? "pm" : "am"},A: function(){return f.a().toUpperCase()},B: function(){// peter paul koch:var off = (jsdate.getTimezoneOffset() 60)*60;var theSeconds = (jsdate.getHours() * 3600) (jsdate.getMinutes() * 60) jsdate.getSeconds() off;var beat = Math.floor(theSeconds/86.4);if (beat > 1000) beat -= 1000;if (beat < 0) beat = 1000;if ((String(beat)).length == 1) beat = "00" beat;if ((String(beat)).length == 2) beat = "0" beat;return beat; },g: function(){return jsdate.getHours() % 12 || 12},G: function(){return jsdate.getHours()},h: function(){return pad(f.g(), 2)},H: function(){return pad(jsdate.getHours(), 2)},i: function(){return pad(jsdate.getMinutes(), 2)},s: function(){return pad(jsdate.getSeconds(), 2)},//u not supported yet// Timezone//e not supported yet//I not supported yetO: function(){var t = pad(Math.abs(jsdate.getTimezoneOffset()/60*100), 4);if (jsdate.getTimezoneOffset() > 0) t = "-" t; else t = " " t;return t; },P: function(){var O = f.O();return (O.substr(0, 3) ":" O.substr(3, 2))},//T not supported yet//Z not supported yet// Full Date/Timec: function(){return f.Y() "-" f.m() "-" f.d() "T" f.h() ":" f.i() ":" f.s() f.P()},//r not supported yetU: function(){return Math.round(jsdate.getTime()/1000)} };return format.replace(/[\\]?([a-zA-Z])/g, function(t, s){if( t!=s ){// escapedret = s; } else if( f[s] ){// a date function existsret = f[s](); } else{// nothing specialret = s; }return ret; });}
调用方法 能够很方便的将时间戳(秒)转换成日期的格式,如:
date('Y-m-d','1537977600'); 转为2018-09-27date('Y-m-d H:i:s','1538015353');转为2018-09-27 10:29:13
MySQL的时间单位是秒
#获取当前时间日期select now(); #2018-09-27 10:41:12#当前日期select curdate(); #2018-09-27#当前时间select curtime(); #10:43:23
#返回日期时间的日期部分date()#返回日期的时间部分time()#返回日期的年份部分year()#给定一个日期date, 返回一个天数 (从年份0开始的天数 )。TO_DAYS() #求两个日期的差,返回天数datediff('20180927','20180101') datediff('2018-09-27','2018-01-01')
#向指定日期添加时间间隔。date_add('20180927',interval 1 day); #返回2018-09-28#指定日期减去时间间隔后的具体日期date_sub('20181224',interval 9 day) #f返回2018-12-15#返回指定日期为全年的第几天dayofyear(日期):
#当前时间戳unix_timestamp()#将时间戳转为日期时间格式select FROM_UNIXTIME(1537977600); #2018-09-27 00:00:00
联系客服