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 votes144 views1 answer
Sql server check for value in multiple columns
SQL
0 vote149 views1 answer
Microsoft sql server python connection
SQL
0 vote169 views1 answer
Sql filter rows with condition
SQL
0 vote148 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
27 votes145 views6 answers
Sql update record
SQL
3 votes89 views1 answer
If 0 return null else return query mysql
SQL
3 votes141 views3 answers
Raw select laravel
SQL
4 votes129 views2 answers
Dbms_scheduler stop job
SQL
4 votes133 views6 answers
Second max salary in sql
SQL
6 votes180 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL