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 votes152 views1 answer
Enum in SQL Server
SQL
4 votes163 views1 answer
Id increment ms sql server
SQL
1 vote177 views1 answer
How to give access to database in postgresql server to another user
SQL
1 vote194 views1 answer
Oracle extract minute from date
SQL
0 vote197 views1 answer
Copy from one table to another postgres using matching column
SQL
15 votes156 views2 answers
Select where duplicate mysql
SQL
-1 vote144 views1 answer
Pl/sql how to delete a trigger
SQL
0 vote145 views1 answer
Min mysql
SQL
0 vote234 views1 answer
Sqlalchemy _in array sqlite
SQL
0 vote145 views1 answer
Fix sqlite3 ruby on rails
SQL