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 vote292 views1 answer
Count the table indatabase
SQL
0 vote295 views1 answer
Mysql add comment to column
SQL
3 votes316 views2 answers
Laravel tosql with bindings
SQL
0 vote293 views1 answer
Sql grant select only
SQL
0 vote284 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
0 vote296 views1 answer
Oracle synonym procedure
SQL
0 vote304 views1 answer
Set open file limit mac catalina mysql
SQL
0 vote309 views1 answer
How to make full text search dynamic in mysql
SQL
1 vote373 views1 answer
Mysql get max value and id
SQL
0 vote317 views2 answers
Functions with parameters SQL
SQL