"how to convert datetime to varchar" Code Answer

with microsoft sql server:

--
-- create test case
--
declare @mydatetime datetime
set @mydatetime = '2008-05-03'

--
-- convert string
--
select left(convert(varchar, @mydatetime, 120), 10)

By Uri Lukach on February 20 2022

Only authorized users can answer the Search term. Please sign in first, or register a free account.

Browse Other Code Languages