【草稿】ORACLE date timestamp 与 字符串 怎么互相转换?SQL中的case when怎么写?
就是to_date, to_char,按需使用
https://www.cnblogs.com/cxxjohnson/p/4841314.html
- case when
CASE search_expression
WHEN expression1 THEN result1
WHEN expression2 THEN result2
...
WHEN expressionN THEN resultN
ELSE default_result