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 vote270 views1 answer
Kill a pid redshift
SQL
0 vote266 views1 answer
Mysql join same table multiple times group by
SQL
0 vote261 views1 answer
Multiple left join mysql
SQL
10 votes283 views4 answers
Else if mysql
SQL
0 vote258 views1 answer
Safe mysql
SQL
0 vote292 views1 answer
Pgadmin save data greyed out
SQL
-3 votes249 views1 answer
Remove spaces sql 2008
SQL
0 vote269 views1 answer
Sql server check whether column has same equal values
SQL
0 vote264 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
1 vote266 views3 answers
Epoch to datetime
SQL