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 vote98 views1 answer
Postgres get running query
SQL
0 vote98 views1 answer
Postgresql add not null and not empty constraint
SQL
0 vote102 views2 answers
Transaction php
SQL
1 vote94 views2 answers
Sql example query
SQL
5 votes105 views1 answer
Mysql count lines
SQL
0 vote107 views1 answer
Utiliser sql ligne de commande
SQL
0 vote104 views1 answer
Access mysql database docker container shell
SQL
0 vote113 views1 answer
Get schema of table sql
SQL
6 votes149 views2 answers
Non relational database
SQL
0 vote97 views1 answer
Grepper sql workbench download
SQL