根据日期找出年月日

• 方式1
  • SELECT EXTRACT (YEAR FROM DATE '2019-08-15') FROM dual;
  • SELECT EXTRACT (MONTH FROM DATE '2019-08-15') FROM dual;
  • SELECT EXTRACT (DAY FROM DATE '2019-08-15') FROM dual;
• 方式2
  • SELECT "SUBSTR"('2019-08-15', 0, 4) FROM dual;
  • SELECT "SUBSTR"('2019-08-15', 6, 2) FROM dual;
  • SELECT "SUBSTR"('2019-08-15', 9, 2) FROM dual;