Answers for "change date format in oracle"

oracle set date format

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MM-YYYY HH24:MI:SS';
SELECT sysdate FROM dual;

SELECT to_char(sysdate,'HH24:MI:SS') FROM dual;

Posted by: Guest on August-01-2021

change date format in oracle query

select to_char(date_column,'YYYY-MM-DD') from table;

Posted by: Guest on August-12-2021

how to update date in oracle

UPDATE T_name 
set column_name 
where = condition ;

Posted by: Guest on November-03-2021

Code answers related to "change date format in oracle"