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

1 vote145 views1 answer
Create procedure with encryption
SQL
0 vote158 views1 answer
Learnxinyminutes sql
SQL
42 votes235 views6 answers
Rename table sql server
SQL
0 vote215 views1 answer
How to get number of months between 2 dates sql server
SQL
-1 vote153 views1 answer
Export mysql table to file
SQL
0 vote146 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
2 votes143 views1 answer
Oracle current date without time
SQL
10 votes142 views6 answers
Mysql delete duplicates
SQL
2 votes132 views2 answers
Get all columns from table sql
SQL
1 vote138 views1 answer
Oracle aleter trigger ora-01031
SQL