In Oracle Database, the TO_DSINTERVAL() function converts its argument to a value of INTERVAL DAY TO SECOND data type.
conversion functions
NUMTOYMINTERVAL() Function in Oracle
In Oracle Database, the NUMTOYMINTERVAL() function converts a number to an INTERVAL YEAR TO MONTH literal.
NUMTODSINTERVAL() Function in Oracle
In Oracle Database, the NUMTODSINTERVAL() function converts a number to an INTERVAL DAY TO SECOND literal.
TO_CHAR(datetime) Function in Oracle
In Oracle Database, the TO_CHAR(datetime) function converts a datetime or interval value to a VARCHAR2 value in the format specified by the date format.
How TO_CHAR() Works in MariaDB
In MariaDB, TO_CHAR() is a built-in string function that converts a date/time expression to a string.
The expression can be a date, datetime, time, or timestamp value.
This function was introduced in MariaDB 10.6.1 to enhance Oracle compatibility.
How TO_SECONDS() Works in MariaDB
In MariaDB, TO_SECONDS() is a built-in date and time function that returns the number of seconds from year 0 to the given date or datetime expression.
How TIME_TO_SEC() Works in MariaDB
In MariaDB, TIME_TO_SEC() is a built-in date and time function that returns its time argument, converted to seconds.
How STR_TO_DATE() Works in MariaDB
In MariaDB, STR_TO_DATE() is a built-in date and time function that returns a datetime value, based on the given date string and format string.
The STR_TO_DATE() function is the inverse of the DATE_FORMAT() function.
How SEC_TO_TIME() Works in MariaDB
In MariaDB, SEC_TO_TIME() is a built-in date and time function that returns a time value, based on the number of seconds provided as arguments.
How TO_DAYS() Works in MariaDB
In MariaDB, TO_DAYS() is a built-in date and time function that returns the number of days from the start of the standard calendar (0000-00-00), based on a given date.
You pass the date to the function when you call it.
The TO_DAYS() function is the converse of the FROM_DAYS() function.