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

2 votes318 views1 answer
Set column to not null mysql
SQL
2 votes322 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
23 votes336 views6 answers
How to create table in sql
SQL
4 votes332 views1 answer
Postgresql list sequences
SQL
11 votes319 views1 answer
Mysql order by two columns priority
SQL
-1 vote330 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
0 vote330 views1 answer
Postgresql show owner of database
SQL
2 votes306 views1 answer
Add 2 hours to current time in MySQL
SQL
4 votes319 views2 answers
Oracle unlock user
SQL
-1 vote327 views5 answers
Operator in sql
SQL