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 vote162 views2 answers
How to display enum value sql server
SQL
1 vote156 views1 answer
Date_part mysql
SQL
0 vote176 views1 answer
Replace \n sql
SQL
0 vote157 views1 answer
How to remove default in mysql
SQL
0 vote147 views1 answer
Get records in sql according to month name and count
SQL
1 vote186 views3 answers
Reseed sql table primary key
SQL
0 vote156 views1 answer
Postgres populate table from another table
SQL
0 vote158 views2 answers
MySQL top percent
SQL
0 vote182 views1 answer
How to create notes in mysql
SQL
0 vote160 views1 answer
Mysql Like(searching in the string)
SQL