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 vote174 views1 answer
Lister les index d'une table oracle
SQL
0 vote189 views1 answer
Save single sql query result boolean spring boot
SQL
0 vote144 views1 answer
Check if due date is less than todays date sql
SQL
10 votes202 views1 answer
User_dependencies
SQL
5 votes195 views3 answers
String concatenation sql server
SQL
0 vote182 views1 answer
Print intervals of 15 minutes in sql query
SQL
6 votes204 views1 answer
Oracle rank
SQL
0 vote198 views1 answer
Firebird where
SQL
1 vote188 views1 answer
Create temporal table in sql
SQL
0 vote194 views1 answer
Mysql count unique in group statement
SQL