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 vote367 views1 answer
Mysql multiple primary keys
SQL
5 votes348 views2 answers
Oracle timestamp to date
SQL
1 vote384 views3 answers
Postgresql get difference between two dates
SQL
18 votes382 views3 answers
Get the list of all tables in sql server
SQL
1 vote383 views1 answer
Deleting database in sql
SQL
0 vote341 views1 answer
Mysql xampp reset root password
SQL
10 votes325 views1 answer
Oracle dependency
SQL
0 vote353 views1 answer
Postgres where
SQL
0 vote433 views1 answer
Parent and child link in mysql
SQL
1 vote359 views3 answers
Mysql Server Start
SQL