李彦祯的专栏

解决mysql数据库 UTC时间和北京时间不一致的问题select sid, case course when "shuxue" then score else 0 end as shuxue, case course when "yuwen" then score else 0 end as yuwen from course;

select avg(t.variations), max(t.datadate), max(lpad(t.datatime,6,'0'))   from t_table t   where t.datadate between '20120101' and '20120131'group by t.datadate,substr(lpad(t.datatime,6,'0'),0,2)

--比较两个字段的大小select decode(substr(m.age - w.age, 0, 1), '-', '小于', '0', '相等', '大于') compare from man m,woman w where m.wifeid=w.id and m.adr=w.adr

select SYSDATE,uptime,(SYSDATE - uptime) * 86400000/60000 diff from t_run_ctrl

select to_char(to_date('201201010100', 'yyyymmddhh24mi') + rownum /(24*60),'yyyymmddhh24mi')                 from dual connect by level <= 10

SELECT LPAD ('1234' , 5 , '0') FROM DUAL 结果：01234

select column_name from user_tab_columns where table_name='D_SA001000'

Insert into D_SA001000  (DAY_HHMMSS,   CENTER,   DEPARTMENT,   STATION,   TYPE,   NUM,   CODE,   PATH,   PARATYPE,   REGID) --'yyyymmddHH24MISS'注意精度，根据表的时间字段设置  select TO_TIMES