/SQL/Oracle timestamp to date

Oracle timestamp to date

Oracle to_timestamp

-- 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;

4

Oracle timestamp to date

CAST(timestamp_expression AS DATE)

1

Similar codes

0 vote138 views1 answer
How to create notes in mysql
SQL
3 votes147 views1 answer
How to uninstall microsoft sql server
SQL
4 votes158 views4 answers
Remove duplicate old value in mysql
SQL
0 vote138 views1 answer
Mysql where in maintain order
SQL
49 votes220 views6 answers
Install mysql ubuntu
SQL
3 votes133 views3 answers
Remove all spaces from string sql
SQL
0 vote119 views1 answer
Materialized view redshift
SQL
5 votes174 views4 answers
Mysql on duplicate key update
SQL
0 vote128 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
5 votes145 views6 answers
In operator sql
SQL

Share