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 vote368 views1 answer
Print hello world in plsql
SQL
0 vote334 views2 answers
Getting customers with no orders sql
SQL
0 vote355 views1 answer
SQL column name Oracle
SQL
0 vote340 views1 answer
How to insert multiple rows in mysql using laravel
SQL
12 votes321 views3 answers
Duplicate a column in sql
SQL
0 vote340 views1 answer
Sql server alter table column nullable
SQL
1 vote322 views1 answer
Sql oracle update multiple rows
SQL
0 vote314 views1 answer
Difference between cross apply and inner join
SQL
0 vote346 views1 answer
Find usage of table in sql server
SQL
1 vote332 views1 answer
Sql Split string function
SQL