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 vote250 views3 answers
Between keyword sql
SQL
0 vote254 views1 answer
Postgres declare variable
SQL
0 vote258 views1 answer
Find and replace database table phpmyadmin
SQL
0 vote268 views1 answer
Mariadb create index if not exists
SQL
8 votes290 views1 answer
Mysql dump restore
SQL
7 votes269 views1 answer
Mysql remote connection command line
SQL
1 vote263 views1 answer
Print all records of table in mysql
SQL
1 vote263 views3 answers
Drop unique key constraint in sql server
SQL
0 vote258 views1 answer
Docker open terminal mysql server
SQL
0 vote243 views1 answer
Sql file in postgres with pgadmin
SQL