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

2 votes353 views4 answers
List databases in sql server
SQL
0 vote328 views2 answers
Mysql output csv
SQL
2 votes351 views1 answer
Mysql virtual column
SQL
1 vote340 views1 answer
Create sqlite database in laravel
SQL
0 vote356 views3 answers
Delete in SQL SERVER
SQL
0 vote374 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote340 views1 answer
Select top 3 sql
SQL
0 vote355 views1 answer
Postgresql delete limit
SQL
2 votes390 views2 answers
Mysql bidirectional composite primary key
SQL
0 vote342 views1 answer
Zerar auto increment mysql
SQL