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 vote328 views1 answer
Sql server alter table column nullable
SQL
1 vote288 views1 answer
Foreign key in oracle sql developer
SQL
13 votes349 views5 answers
Alter table query sql server change column
SQL
6 votes399 views3 answers
What is where in sql
SQL
-1 vote333 views3 answers
SQL MM/dd/yyyy format
SQL
0 vote317 views1 answer
Mysql jdbc timezone
SQL
2 votes280 views1 answer
Oracle current date without time
SQL
0 vote343 views1 answer
Alter boolean column postgresql
SQL
0 vote314 views1 answer
Porcentaje sql
SQL
10 votes303 views2 answers
Mysql select timestamp group by day
SQL