mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-12-11 23:05:44 +01:00
Code Issues Projects Releases Packages Wiki Activity
mariadb/mysql-test/suite/compat/oracle
History
Exact
Monty ed7534c42c MDEV-20023 Implement Oracle TRUNC() function 
It returns the DATETIME data type (which is the closest to Oracle's DATE).

The following Oracle formats are supported:
Truncate to day: DD, DDD,J
Truncate to month: MM,MON,MONTH,RM
Truncate to Year: SYEAR,SYYYY,Y,YEAR,YY,YYY,YYYY

TRUNC(date) is same as TRUNC(date, "DD")

This patch incorporates a fix for:

MDEV-37414 SIGSEGV in Binary_string::c_ptr | Item_func_trunc::get_date

Fixing the problem that the code did not take into
account that args[1] can return SQL NULL.
2025-08-25 11:19:24 +04:00
..
r MDEV-20023 Implement Oracle TRUNC() function 2025-08-25 11:19:24 +04:00
t MDEV-20023 Implement Oracle TRUNC() function 2025-08-25 11:19:24 +04:00