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

6 votes270 views1 answer
Oracle desc table primary key
SQL
1 vote301 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
2 votes291 views1 answer
Db.relationship sqlalchemy flask
SQL
27 votes337 views3 answers
Mysql delete row
SQL
0 vote281 views1 answer
Create schema sql server
SQL
0 vote284 views2 answers
What is the default password for sql server sa
SQL
0 vote280 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote277 views1 answer
Sql trigger to call stored procedure with parameters
SQL
1 vote268 views2 answers
End mysql command
SQL
0 vote274 views1 answer
Oracle gather table statistics
SQL