/SQL/To_char sql

To_char sql

Sql to char function with date

SELECT
  TO_CHAR( sysdate, 'YYYY-MM-DD' )
FROM
  dual;

2

Source: oracletutorial.com

To_char sql

SELECT TO_CHAR(sysdate, 'DD-MM-YYYY') from dual;

1

Similar codes

0 vote328 views1 answer
C# datetime to sql server datetime
SQL
0 vote336 views1 answer
What is ssrs and ssis in sql server
SQL
0 vote328 views1 answer
How to install mysql without admin rights
SQL
15 votes327 views2 answers
Sql order by multiple columns
SQL
0 vote350 views1 answer
Oracle query archive mode
SQL
0 vote328 views1 answer
Mysql docker image for macbook m1
SQL
4 votes340 views1 answer
Mysql ip address data type
SQL
4 votes330 views1 answer
Restart for pg_hba.conf file
SQL
2 votes330 views1 answer
Merge two columns in sql oracle
SQL
2 votes346 views2 answers
Install postgresql
SQL

Share