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

37 votes249 views3 answers
Duplicate records in sql
SQL
2 votes264 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
0 vote265 views1 answer
Change date in pivot table to month in sql server
SQL
0 vote250 views1 answer
Kill thread
SQL
0 vote281 views1 answer
Check if mysql db is used
SQL
0 vote261 views1 answer
How to list function in psql
SQL
0 vote300 views1 answer
Pagination with row_number
SQL
0 vote266 views1 answer
Mysql wait_timeout
SQL
3 votes275 views1 answer
Get current month last date in sql server
SQL
0 vote285 views1 answer
Amount of entries in a table psql
SQL