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 vote270 views1 answer
Sql row number in result set
SQL
9 votes286 views2 answers
Sql limit to 5 results
SQL
1 vote289 views1 answer
Postgres set column based on another column
SQL
2 votes284 views2 answers
Sql query to copy data from one column to another
SQL
0 vote265 views1 answer
Time mysql w3
SQL
0 vote270 views1 answer
Tsql default value when no value returned by query
SQL
8 votes240 views1 answer
Similarities between ddl and dml
SQL
0 vote259 views1 answer
Drop all data from tables
SQL
0 vote286 views3 answers
Insert query in ci
SQL
3 votes278 views1 answer
Force using index plsql
SQL