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 vote138 views1 answer
Call function sql oracle
SQL
1 vote164 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
0 vote159 views1 answer
Sql ignore
SQL
0 vote180 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote159 views1 answer
Oracle procedure teamplate
SQL
0 vote156 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
1 vote165 views1 answer
Add current timestamp in mysql
SQL
0 vote154 views1 answer
GROUP BY postgres
SQL
9 votes154 views1 answer
Oracle get table schema
SQL
0 vote178 views1 answer
Multiple like values for single column postgres
SQL