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 vote227 views1 answer
Google sheets data validation custom formula filter
SQL
2 votes213 views1 answer
Postgresql format date dd/mm/yyyy
SQL
0 vote232 views1 answer
Select lowest values sql
SQL
6 votes237 views1 answer
T-sql test if table exists
SQL
9 votes247 views6 answers
Check constraint in sql
SQL
2 votes242 views1 answer
Where clause for child record apex
SQL
0 vote230 views1 answer
Complete date is 1 year or not sql server
SQL
-1 vote216 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
5 votes251 views4 answers
Traduction
SQL
1 vote188 views1 answer
Ms sql how to see active job current run time
SQL