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

3 votes404 views1 answer
Oracle undo tablespace schema
SQL
0 vote384 views2 answers
Mysql two column combination unique
SQL
0 vote361 views1 answer
Sql select random procentage from rows
SQL
3 votes366 views2 answers
Find the median in sql
SQL
0 vote370 views1 answer
How to add boolean column in postgresql
SQL
0 vote358 views1 answer
Create relationship with betwen two tables in postgersql
SQL
0 vote352 views1 answer
Sql column as header
SQL
0 vote342 views2 answers
How to relationship query two different tables in MySQL
SQL
0 vote349 views1 answer
Sql insert tuple
SQL
6 votes377 views2 answers
Mysql concatenate two columns into one
SQL