mysql与oracle语法转换
- 日期转字符
mysql:date_format(date,’%Y-%m-%d’)
date_format(date,%Y%m%d%H%i%s)
oracle:to_char(date,‘yyyy-MM–dd’);
to_char(date,‘yyyyMMddHHmmss’); - 字符转日期
mysql:str_to_date(date,%Y%m%d%H%i%s)
oracle:to_date(date,‘yyyyMMddHHmmss’) - 取一条结果
mysql:limit 1
oracle:rownum = 1 - 空值校验
-----如果expr1为null,则返回expr2,否则返回expr1
mysql:(1) IFNULL(expr1,expr2)
(2)case
when expr1 is null then expr2
else expr1
end
(3)if(expr1<> null,expr1,expr2 )
oracle:nvl(expr1, expr2)