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 vote187 views1 answer
Save single sql query result boolean spring boot
SQL
0 vote213 views1 answer
Dump db only triggers mysql
SQL
1 vote199 views1 answer
Crontab every month
SQL
0 vote402 views1 answer
Why do we need data structure in sql
SQL
1 vote302 views1 answer
Sql server read uncommitted
SQL
2 votes270 views1 answer
Mysql now format
SQL
1 vote251 views1 answer
Set statiscis on in sql server
SQL
0 vote188 views1 answer
Sql right characters
SQL
0 vote200 views1 answer
Stored procedures example
SQL
0 vote192 views1 answer
Psql select * from table
SQL