SQL Date Format

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')

Sql server obtener fecha en formato dd/mm/yyyy

convert( datetime, fecha, 103 )

Source: social.msdn.microsoft.com

Similar codes

0 vote217 views1 answer
Sql select column name like from multiple tables
SQL
0 vote192 views1 answer
Create api project in visual studio 2019 and sql server
SQL
-1 vote216 views5 answers
Convert sql to linq query online
SQL
2 votes191 views1 answer
Mysql add boolean column
SQL
0 vote234 views1 answer
SQLServerException.makeFromDatabaseError
SQL
7 votes209 views2 answers
Oracle sql drop index
SQL
0 vote209 views1 answer
Migrations.RunSQL
SQL
0 vote179 views1 answer
'0000-00-00' for column '
SQL
0 vote196 views1 answer
Drop specific row postgresql
SQL
-1 vote209 views1 answer
Su: Authentication failure mysql
SQL