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

1 vote174 views1 answer
Postgres grant read only access to database
SQL
7 votes206 views3 answers
How to check table name in current database sql
SQL
0 vote225 views1 answer
Delete a record from a table sqlite3
SQL
1 vote169 views1 answer
Ms sql - add one hour to time
SQL
1 vote201 views1 answer
Psql show with user is logged in
SQL
0 vote227 views1 answer
Get the Db column names from a SqlDataReader
SQL
3 votes228 views1 answer
Locate sql server
SQL
0 vote215 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
7 votes203 views1 answer
Append column sql
SQL
8 votes246 views2 answers
Oracle undo usage
SQL