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 vote348 views1 answer
Set column width in sqlplus
SQL
1 vote380 views1 answer
Psql view enum values
SQL
18 votes355 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
1 vote379 views1 answer
Customer using hdfc bank sql query
SQL
4 votes329 views1 answer
Oracle show error line number
SQL
0 vote403 views1 answer
How to get button for every record from mysql
SQL
3 votes375 views3 answers
Raw select laravel
SQL
3 votes363 views1 answer
How to find names includes in sql
SQL
2 votes342 views1 answer
Apex execute batch job
SQL
2 votes394 views1 answer
Oracle Column Names of a table
SQL