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 vote315 views1 answer
Oracle nvl2
SQL
0 vote293 views2 answers
How to delete the rows with null values in mysql
SQL
1 vote293 views2 answers
Mysql remove first and last character from string
SQL
5 votes342 views1 answer
Oracle source query
SQL
0 vote353 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
1 vote331 views1 answer
Encrypt password postgresql
SQL
24 votes276 views5 answers
Sql reset auto increment
SQL
0 vote294 views2 answers
Get top 1 row of each group
SQL
23 votes314 views3 answers
Sql where contains part of string
SQL
3 votes288 views3 answers
Django.db.utils.OperationalError: no such table:
SQL