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 vote210 views1 answer
Createdb with postgresql on ubuntu
SQL
-1 vote188 views1 answer
How to switch user in mysql
SQL
0 vote229 views1 answer
Getting next sequence value jpa postgress
SQL
0 vote354 views1 answer
Current month transactions in mysql
SQL
8 votes198 views2 answers
Safe update mode in mysql
SQL
0 vote312 views1 answer
How to update random rows in sql
SQL
0 vote246 views1 answer
Mysql subtract month from timestamp
SQL
0 vote197 views2 answers
Close external port 3306 with iptables
SQL
6 votes341 views1 answer
Sql insert values into table
SQL
0 vote192 views1 answer
Resullt all update knex mysql
SQL