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

3 votes127 views2 answers
How to open postgresql in windows
SQL
0 vote127 views1 answer
Starting mysql shell lampp ubuntu
SQL
7 votes134 views4 answers
Index in mysql
SQL
0 vote112 views1 answer
Alter boolean column postgresql
SQL
0 vote122 views1 answer
Can we rollback in sql
SQL
0 vote116 views1 answer
Set classpath for mysql-connector.jar
SQL
6 votes117 views4 answers
Eloquent to sql with bindings
SQL
1 vote128 views1 answer
What is a Database?
SQL
0 vote115 views3 answers
Sql count condition
SQL
1 vote127 views1 answer
Postgres set sequence value to max id
SQL