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 vote186 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
2 votes189 views1 answer
Change primary key sql
SQL
2 votes187 views1 answer
Sql update alias
SQL
1 vote191 views1 answer
Mysql search like order by best match
SQL
25 votes174 views4 answers
Metadata
SQL
1 vote187 views1 answer
Return size of tables in mysql
SQL
0 vote208 views1 answer
Amount of entries in a table psql
SQL
0 vote191 views1 answer
Trigger stock phpmyadmin output message
SQL
0 vote194 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
0 vote181 views1 answer
Mysql add root password
SQL