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 vote157 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
1 vote218 views2 answers
Login to mysql
SQL
1 vote170 views2 answers
Postgresql backup and restore globals and data
SQL
0 vote220 views1 answer
How to compile a function in oracle
SQL
4 votes173 views1 answer
Refresh postgres config
SQL
0 vote203 views1 answer
Check command
SQL
0 vote201 views2 answers
Suse stop MySQL
SQL
3 votes193 views3 answers
Update con select postgresql
SQL
0 vote170 views1 answer
Write sql query to show the details start from digit
SQL
33 votes157 views2 answers
Postgres how to add field created at
SQL