Here are the examples of Oracle SQL queries to get the day from date. SQL Query to Get Full Day Name from the Date select to_char(sysdate, 'DAY') full_name from dual; Output: SUNDAY To Get Short Day Name select ...
Discy Latest Articles
Oracle SQL Query to Split a String
The following are examples to split a string in Oracle using SQL query. Split a String Using regexp_substr() Function in Oracle The below query will split the string separated by comma using regexp_substr() function: select regexp_substr('A,B,C,D', '[^,]+', 1, level) from ...
Oracle Convert Timestamp to Date
In Oracle, to get the current timestamp, use SYSTIMESTAMP, and if you want to convert timestamp to date, use the CAST() function. Below is an example: Using CAST() Function to Convert Timestamp to Date in Oracle The following is the ...