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

4 votes316 views2 answers
Error loading MySQLdb module.
SQL
0 vote360 views2 answers
Dbms transaction tutorialspoint
SQL
0 vote363 views2 answers
Execute stored procedure without db set
SQL
0 vote352 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
6 votes356 views4 answers
Mysql update set
SQL
5 votes350 views2 answers
Oracle find all tables with column name
SQL
6 votes380 views6 answers
Rename column postgres
SQL
4 votes314 views1 answer
Postgresql show current database
SQL
29 votes325 views6 answers
Delete all rows from table mysql
SQL
3 votes318 views2 answers
Pl sql escape '
SQL