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 vote196 views2 answers
Get all index postgres
SQL
0 vote184 views1 answer
Execut sql python
SQL
1 vote196 views1 answer
Postgresql escape single quote
SQL
15 votes189 views1 answer
Mysql int range
SQL
4 votes186 views1 answer
Postgres delete last row
SQL
0 vote193 views5 answers
Mode sql course
SQL
0 vote208 views1 answer
Dataframe lambda elif
SQL
0 vote184 views1 answer
Check sql database table lock
SQL
0 vote232 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
1 vote202 views1 answer
Describe table in sql
SQL