SELECT SUBSTRING(CONVERT(VARCHAR, DATEADD(MINUTE,-1,GETDATE()), 22),9,6) + ' ' + SUBSTRING(CONVERT(VARCHAR, DATEADD(MINUTE,-1,GETDATE()), 22),19,2) AS Currenttime
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)