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

4 votes192 views2 answers
Tables in sql
SQL
25 votes274 views6 answers
Change column name mysql
SQL
0 vote168 views1 answer
18446744073709551615 mariadb left join order by
SQL
0 vote157 views1 answer
Running query in redshift
SQL
0 vote201 views1 answer
Sqlite get date only
SQL
3 votes178 views2 answers
Postgres show table schema
SQL
0 vote174 views1 answer
Get time component of datetime sql
SQL
0 vote167 views1 answer
Oracle index hint
SQL
0 vote164 views2 answers
Drop check constraint in ms sql
SQL
0 vote170 views1 answer
Difference between varchar and varchar2
SQL