To date oracle

To date oracle with time

-- TO_TIMESTAMP(date_string,'YYYY-MM-DD HH24:MI:SS')
SELECT TO_TIMESTAMP('2021-02-21 23:12:01','YYYY-MM-DD HH24:MI:SS') FROM DUAL;

To date oracle

SELECT TO_DATE('14/07/2021','DD/MM/YYYY') FROM DUAL;

                                  WATCH OUT! 
/*	  in the example before if you write '14072021' instead of '14/07/2021'
      you'll get the same result, if you want an exception to be thrown you    
      should add the prefix 'fx' (force) to the format, so that he will 
      match only the exact format. here's some examples:
         SELECT TO_DATE('14/07/2021','fxDD/MM/YYYY') FROM DUAL;--WORKS
         SELECT TO_DATE('14072021','DD/MM/YYYY') FROM DUAL;    --WORKS
         SELECT TO_DATE('14072021','fxDD/MM/YYYY') FROM DUAL;--EXCEPTION      */

Similar codes

0 vote128 views1 answer
T-SQL Create Trigger
SQL
0 vote129 views1 answer
Regex any word except sql
SQL
9 votes124 views4 answers
Mysql set id auto increment
SQL
19 votes117 views3 answers
Grant mysql
SQL
0 vote119 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote87 views1 answer
Copy data from cell to cell mysql
SQL
0 vote137 views1 answer
Except in sql
SQL
23 votes127 views1 answer
How remove column in mysql
SQL
1 vote147 views1 answer
Show databases mysql docker
SQL
0 vote141 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL