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

11 votes126 views4 answers
MYSQL LOGIN
SQL
7 votes134 views4 answers
Database dump mysql command
SQL
0 vote155 views1 answer
Sql anywhere create procedure
SQL
8 votes128 views1 answer
Oracle current date plus 1 month
SQL
0 vote125 views1 answer
Write sql query to show the details start from digit
SQL
0 vote243 views1 answer
Install mysql on bash
SQL
0 vote109 views1 answer
Count the table indatabase
SQL
0 vote141 views1 answer
Modificar tipo de dato sql server
SQL
0 vote130 views2 answers
How to count codition
SQL
7 votes137 views2 answers
Create mysql user
SQL