PL/SQL parser - Phase 2 (MDEV-10764)

[MDEV-11300] sql_mode=ORACLE: CURRENT_DATE function Created: 2016-11-17  Updated: 2019-02-14

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Technical task Priority: Major
Reporter: Dmitry Tolpeko Assignee: Dmitry Tolpeko
Resolution: Unresolved Votes: 0
Labels: Compatibility


 Description   

In Oracle, CURRENT_DATE function returns a datetime value.

 Comments   
Comment by Dmitry Tolpeko [ 2016-11-17 ]

For example, 

SQL> alter session set nls_date_format='YYYY-DD-MM HH24:MI:SS';
 
 
 
Session altered.
 
 
 
SQL> select current_date from dual;
 
 
 
CURRENT_DATE
 
-------------------
 
2016-17-11 13:50:21

Generated at Thu Feb 08 07:48:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.