数据库相关

1、数据库日期字段转固定格式字符串(oracle)

select
“name”,
to_char(“createDate”,‘YYYY-MM-DD’) “createDate”,
to_char(T.msg_create_time, ‘yyyy-MM-dd HH24:MI:SS’) msgCreateTime

2、Oracle分页sql

#不带排序的
SELECT * FROM (
SELECT ROWNUM AS rowno, t.* FROM worker t where ROWNUM <=20) table_alias 
WHERE table_alias.rowno > 10;

#带排序的
SELECT * FROM (
SELECT tt.*, ROWNUM AS rowno FROM (  
SELECT t.* FROM worker t ORDER BY wkid aSC) tt WHERE ROWNUM <= 20) table_alias 
WHERE table_alias.rowno >= 10;