DAYOFWEEK feature introduction
Details
| Detail name | Value |
|---|---|
| Changelog Number | 28977 |
| Type | New Feature |
| Status | Resolved |
| Fix Versions | Exasol 2026.1.0 |
| Resolution Date | 2026-05-15 |
Background
Exasol provides scalar functions https://docs.exasol.com/db/latest/sql_references/functions/scalarfunctions.htm, including functions to manipulate date/time, strings, numeric, etc.
New Feature
A new function DAYOFWEEK was added.
This function returns the Day of week from the provided DATE , TIMESTAMP, or TIMESTAMP WITH LOCAL TIMEZONE. It also accepts strings which are cast-able into the respective types. The DAYOFWEEK output will be based on the session parameter NLS_FIRST_DAY_OF_WEEK which defaults to Sunday as the first day of week.
Example
SELECT DAYOFWEEK(DATE '2003-01-02') ;
Result
| DAYOFWEEK(DATE '2003-01-02') |
|---|
| 5 |
For more details, see DAYOFWEEK documentation in Scalar Functions (will be added when the feature is released).
