Answers for "convert column data type varchar to datetime in sql server"

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)

Posted by: Guest on July-28-2021

sql cast date to 103

cast date to 103

Posted by: Guest on June-15-2021

Code answers related to "convert column data type varchar to datetime in sql server"