摘要:
一、字符串转日期下面将讲述如何在MYSQL中把一个字符串转换成日期:背景:rq字段信息为:201009011、无需转换的:SELECT * FROM tairlist_day WHERE rq>'2010-07-31' AND rq'2010-08-01' AND DATE_FORMAT( rq, ... 阅读全文
摘要:
如何判断js中的数据类型:typeof、instanceof、 constructor、 prototype方法比较如何判断js中的类型呢,先举几个例子:var a = "iamstring.";var b = 222;var c= [1,2,3];var d = new Date();var e ... 阅读全文
摘要:
update operator t set t.username = (select username from operator AS OF TIMESTAMP TO_TIMESTAMP('20150205 12:00:00','YYYYMMDD HH24:MI:SS') where id = t... 阅读全文