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 vote97 views1 answer
Hibernate xml property MySQL url, username and password
SQL
0 vote93 views1 answer
Find and replace database table phpmyadmin
SQL
0 vote96 views1 answer
How to find unique key in sql
SQL
0 vote101 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
-1 vote132 views2 answers
Sql search all tables for attributes
SQL
-1 vote101 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
10 votes100 views4 answers
Drop primary key
SQL
1 vote121 views1 answer
Get parameter value in mysql trigger
SQL
0 vote97 views1 answer
Postgres : ERROR: division by zero
SQL
0 vote111 views1 answer
T sql return on letters only
SQL