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

20 votes99 views1 answer
Get all table name in sql through php
SQL
1 vote120 views1 answer
Mysql select for update ejemplo
SQL
1 vote89 views1 answer
Foreign key constraint in ms sql
SQL
0 vote100 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
0 vote94 views1 answer
Mysql start of today
SQL
0 vote103 views1 answer
Mysql Selected All Duplicate Rows
SQL
2 votes97 views1 answer
How to check grants on a package in oracle
SQL
0 vote172 views1 answer
Install ms sql server management studio
SQL
0 vote103 views1 answer
Typeorm raw sql
SQL
0 vote102 views1 answer
Oracle merge insert if not exists
SQL