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 vote93 views1 answer
Sql transact create cursor with dynamic tables
SQL
1 vote100 views1 answer
Mysql find tables with column name
SQL
0 vote96 views2 answers
Functions with parameters SQL
SQL
1 vote94 views1 answer
Sql select contem uma palavra
SQL
1 vote96 views1 answer
Mysql average of multiple columns
SQL
1 vote208 views3 answers
Create table from existing table in sql
SQL
0 vote94 views2 answers
Postgresql create role
SQL
-1 vote107 views4 answers
Restart mysql server ubuntu
SQL
0 vote102 views1 answer
Extract sql from query object sqlalchemy
SQL
51 votes206 views6 answers
Opera gx
SQL