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 votes136 views2 answers
Mysql alter column default
SQL
1 vote129 views1 answer
Postgresql contains
SQL
0 vote138 views1 answer
How to alter length character varying postgres
SQL
0 vote132 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
14 votes138 views3 answers
Oracle sql limit results
SQL
0 vote132 views1 answer
Every Derived yable must have its own alias
SQL
0 vote127 views1 answer
How to use sqlcommand
SQL
0 vote151 views1 answer
Sql developer format sql
SQL
4 votes136 views1 answer
Select first and last row sql
SQL
11 votes131 views1 answer
Ddl view
SQL