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 vote113 views2 answers
Sql join on comma separated field
SQL
0 vote119 views1 answer
How to add boolean column in postgresql
SQL
1 vote123 views1 answer
Mysql column start with string
SQL
0 vote225 views1 answer
Multiple replace value mssql
SQL
0 vote108 views1 answer
Oracle index hint multiple tables example
SQL
2 votes138 views1 answer
Postgresql transaction
SQL
0 vote132 views1 answer
Recently updated stored procedure in sql server
SQL
0 vote126 views1 answer
Oracle list partitions
SQL
0 vote119 views1 answer
Remove mysql from centos 7
SQL
4 votes81 views2 answers
Select todays data postgres query
SQL