Answers for "convert date and time to datetime sql"

sql timestamp to date

date_format(from_unix_time(`my_date`), '%e %b %Y') AS 'date_formatted'
cast(my_date as DATE)

Posted by: Guest on April-25-2021

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

Code answers related to "convert date and time to datetime sql"