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

7 votes225 views4 answers
Database dump mysql command
SQL
1 vote229 views1 answer
Python escape mysql
SQL
0 vote219 views1 answer
Mysql show foreign keys column
SQL
0 vote247 views1 answer
Delete duplicate rows
SQL
0 vote278 views1 answer
Postgres docs /copy metacomand
SQL
0 vote209 views1 answer
Sql comparison operators
SQL
0 vote239 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
2 votes229 views2 answers
Mysql show table column comments sql
SQL
3 votes233 views3 answers
Sql last week
SQL
0 vote222 views1 answer
Python mysql executemany
SQL