Here are some examples of Oracle SQL queries to convert string to date. Oracle to_date() Function Examples to Convert String to Date To convert a string to date, you will have to follow the same date format in which your ...
Discy Latest Articles
Oracle SQL Query to Get Data for a Particular Date
Here are the examples of Oracle SQL queries to get data for a particular date. Get Data from Oracle Table for a Particular Date To get data from the Oracle table for a particular date: select * from demo_orders where ...
Oracle SQL Query to Get Day from Date
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 ...
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 ...