Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

How to Remove milliseconds from Date time

-- SQL Server
declare @dt datetime
set @dt = '2020–02–21 11:22:32.000'
select @dt as ts, convert(varchar,@dt,120) as newts
Source by medium.com #
 
PREVIOUS NEXT
Tagged: #How #Remove #milliseconds #Date #time
ADD COMMENT
Topic
Name
3+2 =