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 vote179 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote158 views1 answer
Check psql validity function
SQL
0 vote170 views1 answer
Pl sql constraint user function
SQL
1 vote196 views1 answer
Trim leading zeros in sql
SQL
0 vote176 views1 answer
Openquery join two tables
SQL
3 votes290 views6 answers
Sql unique select
SQL
20 votes169 views5 answers
Reset auto increment mysql
SQL
0 vote165 views1 answer
Composit key in sql
SQL
1 vote184 views2 answers
Mysql between
SQL
0 vote180 views2 answers
Nested query
SQL