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

7 votes153 views2 answers
Sql server drop temp table if exists
SQL
0 vote151 views1 answer
Oracle calculate statistics on partition
SQL
2 votes152 views1 answer
Oracle convert run_duration to number
SQL
1 vote142 views1 answer
Psql connections
SQL
0 vote142 views1 answer
Limit and offset in stored procedure mssql
SQL
-2 votes152 views1 answer
Mysql see users and passwords
SQL
5 votes139 views5 answers
Sqlite install python
SQL
0 vote134 views1 answer
Select all tables linked server sql
SQL
2 votes137 views1 answer
Mysql query unique column
SQL
1 vote153 views2 answers
Restart identity cascade
SQL