Date format in sql

Sql server convert string to date

select Cast( '2021-09-22' as date ) as castedDate;
select convert(date,'20210922') as convertedDate;

SQL Date Format

SELECT FORMAT(dbo.column, 'M/dd/yyyy')

Date format in sql

SELECT CONVERT(VARCHAR, GETDATE(),101) AS DATE
SELECT CONVERT(VARCHAR, GETDATE(),102) AS DATE
SELECT CONVERT(VARCHAR, GETDATE(),103) AS DATE
SELECT CONVERT(VARCHAR, GETDATE(),104) AS DATE
SELECT CONVERT(VARCHAR, GETDATE(),105) AS DATE
SELECT CONVERT(VARCHAR, GETDATE(),106) AS DATE

SELECT DATE = FORMAT(GETDATE(), 'dd-MM-yyyy')

Similar codes

0 vote185 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
8 votes175 views1 answer
Script to add datafile to tablespace
SQL
12 votes177 views6 answers
How to install sqlite3 in python
SQL
0 vote166 views2 answers
Sql if empty then
SQL
0 vote156 views1 answer
Sql random decimal
SQL
1 vote178 views1 answer
Use of now() in mysql
SQL
10 votes169 views4 answers
Mysql one week ago
SQL
0 vote125 views1 answer
Oracle sysdba connect as another user
SQL
0 vote217 views1 answer
Reset a table's identity column and remove test records
SQL
2 votes184 views2 answers
Create table mysql integer NOT null
SQL