Skip to content

Instantly share code, notes, and snippets.

select * from t_eve_wechat_verification_code where age(now(),ctime) < ('00:05:00.00000')::interval;
select age(now(),ctime) < interval '00:05:00.00000' from t_eve_wechat_verification_code ;
select age(now(),ctime) from t_eve_wechat_verification_code ;
select date_part('minute',interval '2 years 2 days 23:14:01.92202');
select extract(day from interval '2 years 2 days 23:14:01.92202');
@JohnHello
JohnHello / LUIS
Last active April 26, 2017 01:28
查看了微软LUIS语义理解服务,看到支持语言中有Node.js,Python,还有C#,竟然不支持Java,想了半天,原来是微软家的东西。
@JohnHello
JohnHello / JavaFun.markdown
Last active April 21, 2017 03:16
开通了我的微信订阅号:JavaFun 欢迎订阅,不定期推送 java 冷门小知识

JavaFun
二维码

@JohnHello
JohnHello / Analytics.markdown
Created April 21, 2017 02:05
Google Analytics Beacon Analytics

Analytics

function throttle( fn, time ) {
var t = 0;
return function() {
var args = arguments, ctx = this;
clearTimeout(t);
t = setTimeout( function() {
fn.apply( ctx, args );
}, time );
};
@JohnHello
JohnHello / 0_reuse_code.js
Created April 21, 2017 01:49
Here are some things you can do with Gists in GistBox.
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console