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 vote250 views1 answer
Sql query for login with email or username
SQL
0 vote205 views1 answer
Mysql procedure between two tables
SQL
0 vote219 views1 answer
Time data type in mysql
SQL
1 vote210 views1 answer
Delete from inner join sql
SQL
2 votes214 views1 answer
Compare date in sql
SQL
0 vote211 views1 answer
Create a table from one field of another table
SQL
0 vote193 views1 answer
Oracle list dblink
SQL
1 vote220 views1 answer
Mysql datetime with timezone offset
SQL
14 votes216 views4 answers
Remove record from table sql
SQL
7 votes191 views1 answer
Forge server hosting
SQL