how to convert float to timestamp in single select query for exp. i have float as 1.251152515236 , i want to convert this to datetime and from datetime to timestamp... i.e. 26:11:00
You mean seconds to a Format i.e hh:mm:ss
SELECT CONVERT(varchar, DATEADD(ms, 1.251152515236 * 1000, 0), 114)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)