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

7 votes240 views2 answers
Oracle sql drop index
SQL
3 votes232 views4 answers
Mysql decimal
SQL
5 votes238 views1 answer
Oracle ora-00054 resource busy
SQL
0 vote224 views1 answer
Difference between cross apply and inner join
SQL
18 votes240 views4 answers
Uninstall mysql ubuntu 18.04
SQL
0 vote242 views1 answer
Query to remove duplicate rows from a table
SQL
0 vote240 views1 answer
Sql server datetime to string
SQL
25 votes228 views4 answers
Metadata
SQL
1 vote252 views2 answers
Sql server find all foreign keys that reference a column
SQL
0 vote234 views1 answer
Dump multiple tables mysql
SQL