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

1 vote229 views2 answers
Changes not showing on website server odoo
SQL
5 votes144 views1 answer
Postgres upsert
SQL
0 vote195 views1 answer
Mariadb maximum left join
SQL
0 vote147 views1 answer
Update set with join pl sql
SQL
0 vote172 views1 answer
Mysql update sequence with order by
SQL
0 vote181 views2 answers
Mysql output csv
SQL
7 votes196 views2 answers
Oracle sql drop index
SQL
0 vote214 views1 answer
Print intervals of 15 minutes in sql query
SQL
1 vote233 views2 answers
Limit sqlserver
SQL
-1 vote244 views3 answers
Error: mysql shutdown unexpectedly.
SQL