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

1 vote314 views1 answer
Postgres set column based on another column
SQL
0 vote192 views2 answers
Timing sql queries
SQL
0 vote193 views1 answer
Postgresql in vs any performance
SQL
-1 vote188 views1 answer
Io
SQL
0 vote192 views1 answer
Sql decode
SQL
0 vote175 views2 answers
Mysql output csv
SQL
0 vote204 views1 answer
Sql log file inof
SQL
0 vote204 views1 answer
How to get parent and child record in single query using sql
SQL
1 vote181 views1 answer
Mariadb case switch
SQL
6 votes267 views2 answers
Non relational database
SQL