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 vote77 views1 answer
Mitigation of sql injection
SQL
3 votes119 views3 answers
List columns in table postgres
SQL
0 vote118 views1 answer
Sql how to get courses that i have made prerequisites
SQL
3 votes113 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
5 votes124 views3 answers
Oracle first day of last year
SQL
3 votes129 views2 answers
Sqlite show table structure
SQL
5 votes114 views1 answer
Mysql get last day of month
SQL
0 vote151 views1 answer
Sparql if bound query
SQL
1 vote115 views1 answer
Hexadec to sql REDSHIFT
SQL
2 votes128 views2 answers
Install postgresql
SQL