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

-2 votes296 views1 answer
How-to-remove-mysql-root-password
SQL
1 vote284 views1 answer
Add multiple row table pl sql
SQL
0 vote274 views1 answer
Contact mysql column field
SQL
23 votes266 views3 answers
Mysqldump
SQL
0 vote263 views2 answers
Update all linkedserver tables with openquery on db
SQL
12 votes265 views5 answers
Sql primary key
SQL
4 votes262 views1 answer
Oracle user tables
SQL
2 votes273 views4 answers
List databases in sql server
SQL
0 vote276 views1 answer
Monthly Birthday SQL Query
SQL
0 vote271 views1 answer
Oracle current session details
SQL