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 vote157 views1 answer
Sql last time database was accessed
SQL
0 vote179 views1 answer
Mysql could not fetch tables
SQL
5 votes130 views4 answers
Describe table postgres
SQL
12 votes146 views6 answers
Select distinct
SQL
0 vote134 views1 answer
Add sqlite3 in lumen
SQL
1 vote130 views1 answer
Regular expression in sql server
SQL
0 vote141 views1 answer
Prodection ready postgres database step by step
SQL
0 vote143 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
3 votes123 views1 answer
Oracle failed login attempts
SQL
0 vote162 views2 answers
Oracle ora-00054 how to unlock
SQL