SQL

sql server convert string to date

select Cast( '2021-09-22' as date ) as castedDate;
select convert(date,'20210922') as convertedDate;

convert date to datetime sql

-- 2 ways 
SELECT CONVERT(datetime, '2021-01-01');
SELECT CAST('2021-01-01' AS datetime);

sql convert varchar to date

SELECT convert(datetime, '09/10/2019', 101);

How to convert DateTime to VarChar SQL

-- Create test case
DECLARE @myDateTime DATETIME
SET @myDateTime = '2008-05-03'
-- Convert string
SELECT LEFT(CONVERT(VARCHAR, @myDateTime, 120), 10)

sql convert varchar to date

SELECT convert(datetime, '09/10/2019', 101);

cast datetime to date in sql

SELECT CONVERT(date, getdate());

sql convert datetime

declare @Existingdate datetime
Set @Existingdate=GETDATE()
Select CONVERT(varchar,@Existingdate,103) as [DD/MM/YYYY]

sql datitime to date

CONVERT(DATE, datetime_expression)