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 vote158 views1 answer
Mysql limit results to 10
SQL
0 vote96 views1 answer
How to see the content of tables in pgadmin
SQL
1 vote145 views1 answer
Oracle update with sequence
SQL
5 votes181 views3 answers
Sql limit offset
SQL
0 vote138 views1 answer
Delete insert record in sql server
SQL
0 vote146 views1 answer
Mysql return column names when table is empty
SQL
2 votes157 views1 answer
Power query concatenate
SQL
0 vote139 views1 answer
Firebase sql
SQL
0 vote171 views1 answer
Sql alter column name sql server
SQL
0 vote158 views1 answer
Can you write relational algebra into sql queries
SQL