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

2 votes314 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
5 votes295 views1 answer
Ascending order and where in sql
SQL
1 vote306 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
0 vote303 views2 answers
How to list all values of a column that start with a letter in sql
SQL
1 vote317 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
3 votes283 views1 answer
What is having clause
SQL
0 vote309 views1 answer
Case insensitive sql
SQL
0 vote309 views1 answer
How to move a column to different spot mysql
SQL
0 vote297 views1 answer
Why mysql is used?
SQL
0 vote329 views1 answer
Mysql where don't have string
SQL