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

3 votes150 views1 answer
Difference sql vs mysql
SQL
0 vote208 views1 answer
Use mysql in java program
SQL
1 vote174 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote181 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
4 votes170 views2 answers
Sql vs mysql
SQL
0 vote175 views5 answers
Mode sql course
SQL
59 votes7.7K views6 answers
Alter table sql
SQL
0 vote163 views1 answer
Csv to sqlite python
SQL
0 vote172 views1 answer
Update table sql multiple set
SQL
0 vote215 views1 answer
Postgresql import data from csv
SQL