SYSDATE Compatibility Adaptation
Mar 26, 2025
Table of Contents
- 1. Key SQL Logic in Source Oracle Database
- 2. SQL Refactoring Plan for Target OceanBase
- 3. Refactoring Summary
1. Key SQL Logic in Source Oracle Database
DELIMITER $$
...
SELECT
...
TEST_CODE(BB.ORDER_CODE,SYSDATE(),1,0) AS AA_CODE,
TEST_CODE(BB.ORDER_CODE,SYSDATE(),1,1) AS AA_DEPT_CODE,
OP_SEND(BB.ORDER_CODE) AS IS_SEND,
...
END;
$$
2. SQL Refactoring Plan for Target OceanBase
DELIMITER $$
...
SELECT
...
TEST_CODE(BB.ORDER_CODE,SYSDATE,1,0) AS AA_CODE,
TEST_CODE(BB.ORDER_CODE,SYSDATE,1,1) AS AA_DEPT_CODE,
OP_SEND(BB.ORDER_CODE) AS IS_SEND,
...
EN
3. Refactoring Summary
- Function replacement: change
SYSDATE()toSYSDATEto comply with OceanBase syntax requirements.
Image credit: Designed by Freepik
