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 vote224 views1 answer
Sql server query all database objects
SQL
0 vote127 views1 answer
Postgres list all triggers
SQL
3 votes116 views1 answer
Increment integer in table sql
SQL
0 vote105 views1 answer
How to fix mysql stop unexpectedly
SQL
4 votes116 views1 answer
Wilayah indonesia sql
SQL
1 vote108 views1 answer
Get last week data in mysql
SQL
12 votes124 views10 answers
Google
SQL
1 vote109 views1 answer
Select tables with name like mysql
SQL
0 vote118 views1 answer
Helptext in sql
SQL
0 vote124 views1 answer
Excel vba import data to sql server
SQL