jxycms
9/11/2017 - 1:33 AM

format datetime in query string

format datetime in query string

format datetime in query string
content_copyfile_download
convert(varchar(5),Production.TimeSpent ,108) as 'Duration (HH:MM)
result 11:44

CONVERT(VARCHAR,o.ActualDeliveryTime,101) +' '+RIGHT (CONVERT(VARCHAR,o.ActualDeliveryTime, 100) ,7) as Date
result 10/29/2016 11:44AM