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 vote222 views2 answers
Create table if not exist
SQL
6 votes206 views2 answers
Sql display max value
SQL
2 votes223 views1 answer
Column names in oracle sql
SQL
0 vote206 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote198 views1 answer
Mariadb LOAD DATA INFILE
SQL
0 vote196 views1 answer
Match end of string regex sql
SQL
0 vote239 views1 answer
Gcloud sql instance list
SQL
1 vote204 views1 answer
Quit mysql
SQL
35 votes212 views6 answers
Postgres
SQL
0 vote196 views1 answer
Apache Derby: Create SQL Dump with data
SQL