Date format in sql

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')

Similar codes

0 vote182 views1 answer
Oracle call a function in a insert statement
SQL
1 vote181 views1 answer
Get table column names sql ssms
SQL
7 votes172 views1 answer
Forge server hosting
SQL
10 votes186 views4 answers
Sql pagination
SQL
5 votes259 views1 answer
Purge undo tablespace oracle 11g
SQL
0 vote190 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
2 votes193 views1 answer
How to make insert script from table in SQL server
SQL
0 vote185 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
0 vote193 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
0 vote178 views2 answers
Postgres default user
SQL