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 vote115 views1 answer
Plsql trigger insert update
SQL
0 vote148 views1 answer
Sql gather statistics to increase performance
SQL
6 votes153 views1 answer
Phpmyadmin password root
SQL
1 vote167 views2 answers
Oracle create synonym
SQL
0 vote178 views1 answer
This week mysql
SQL
21 votes126 views7 answers
Table drop if exist sql server
SQL
2 votes177 views1 answer
Sqlite insert if not exists
SQL
3 votes195 views2 answers
How to open postgresql in windows
SQL
0 vote148 views1 answer
Sql server get date of previous sunday
SQL
9 votes145 views3 answers
Show table columns mysql command line
SQL