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 vote120 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
0 vote140 views1 answer
How to access to mysql without root
SQL
0 vote128 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
0 vote130 views1 answer
We are intrested to work with your organization
SQL
0 vote253 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
1 vote125 views1 answer
How to get the date diff on once field in sql server
SQL
0 vote129 views1 answer
Oracle drop default value
SQL
1 vote125 views1 answer
Oracle convert run duration to number
SQL
5 votes121 views1 answer
Mysql change primary key
SQL
1 vote130 views3 answers
Mysql Server Start
SQL