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 vote292 views1 answer
Which lock mode is not available in sql
SQL
0 vote383 views1 answer
Play framework connection via windows sql server
SQL
0 vote301 views1 answer
Mssql + bit + in python orm
SQL
2 votes286 views3 answers
How to pass password mysql command line
SQL
0 vote278 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
0 vote283 views1 answer
Postgresql where clause not working
SQL
0 vote289 views1 answer
Odd record sql query
SQL
13 votes273 views3 answers
Sql online code
SQL
0 vote331 views1 answer
FIND most frequent word in sql server
SQL
1 vote243 views1 answer
Postgres division by zero
SQL