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

1 vote154 views2 answers
Setval max id postgresql sequence
SQL
3 votes134 views1 answer
Sql multiple column index
SQL
0 vote212 views1 answer
Alter table name including schema
SQL
24 votes149 views6 answers
Alter table name sql
SQL
1 vote138 views2 answers
Mysql: command not found
SQL
0 vote140 views1 answer
Max mysql
SQL
0 vote147 views1 answer
Sql remove first character from string
SQL
2 votes133 views1 answer
Oracle number to percentage
SQL
0 vote144 views1 answer
Hibernate with springboot mysql
SQL
1 vote151 views1 answer
Add multiple row table pl sql
SQL