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

5 votes144 views2 answers
Mysql dump mysql db cli
SQL
1 vote116 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
1 vote143 views1 answer
Mysql print variable
SQL
0 vote114 views2 answers
Sql day from datetime
SQL
2 votes116 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
1 vote117 views1 answer
Truncate left characters mysql
SQL
0 vote118 views1 answer
Assign value to var in SQL
SQL
0 vote111 views1 answer
Change permission to database mysql
SQL
8 votes127 views10 answers
Sql
SQL
3 votes106 views2 answers
Mysql add 2 hours
SQL