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 vote275 views1 answer
Sql date d'aujourd'hui
SQL
0 vote275 views1 answer
Two inner joins sql
SQL
0 vote271 views1 answer
Sqlite higher or equal
SQL
103 votes440 views2 answers
Sql server LIKE '%%'
SQL
0 vote266 views1 answer
Calculate date and convert to yearsmysql
SQL
0 vote287 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
0 vote268 views1 answer
Postgres sql alter table delete row
SQL
0 vote279 views1 answer
Sql server create constraint
SQL
0 vote292 views1 answer
Order child below the parent in mysqli
SQL
0 vote288 views1 answer
Sql query contains multiple ids
SQL