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 vote142 views1 answer
Drop-toys-table
SQL
0 vote145 views1 answer
Databricks install odbc driver connect to sql server
SQL
1 vote161 views1 answer
Sql set auto increment back to 0
SQL
0 vote176 views1 answer
Mariadb used space
SQL
0 vote141 views1 answer
Mysql query to add hours to column in table
SQL
8 votes136 views2 answers
Mysql get first x characters
SQL
0 vote125 views1 answer
Compare field sql server
SQL
0 vote299 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
5 votes143 views2 answers
Sql server port number
SQL
0 vote167 views1 answer
Flask sqlalchemy session delete
SQL