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

1 vote135 views2 answers
Laravel get sql query eloquent with parameters
SQL
18 votes149 views3 answers
Mysql add column default value
SQL
0 vote152 views1 answer
How to remove quotes from a string in ssis load file
SQL
1 vote120 views1 answer
Floor function in sql oracle
SQL
0 vote147 views1 answer
Get last updated row sql server
SQL
1 vote126 views1 answer
Scaffold mysql database
SQL
3 votes126 views3 answers
Mysqldump: couldn
SQL
1 vote147 views1 answer
Mysql order by desc null last
SQL
-1 vote131 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
0 vote135 views1 answer
Mysql_num_fields in mysqli
SQL