/SQL/Sql change date format

Sql change date format

Sql change date format

-- Oracle
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MM-YYYY HH24:MI:SS';
SELECT sysdate FROM dual;

SELECT to_char(sysdate,'HH24:MI:SS') FROM dual;

0

Similar codes

0 vote107 views1 answer
Mysql zerofill
SQL
0 vote103 views1 answer
Cross apply top for each row t1
SQL
0 vote103 views1 answer
Postgres float to int
SQL
-2 votes108 views1 answer
Remove root password mysql
SQL
1 vote105 views2 answers
How to check if sql query is correct online
SQL
3 votes110 views2 answers
Get current year sql
SQL
0 vote108 views1 answer
Oracle array
SQL
0 vote102 views1 answer
Oracle current session details
SQL
28 votes104 views6 answers
Mysql change user password
SQL
0 vote99 views1 answer
Pl sql join 3 tables
SQL

Share