Answers for "mssql datetime convert datetime"

SQL
1

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
6

sql server convert string to date

Cast( '2011-07-07' as date ) as convertedDate
Posted by: Guest on April-06-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language