Convert TIME to Seconds in MSSQL

 

Just put in the Time, and it will return the Seconds

DECLARE @Time Varchar(10)

SELECT DATEDIFF(second,0,cast(@Time as datetime))


Comments

Post a Comment

Popular posts from this blog

Mvc Razor Load Partial view using javascript

You can just load the Partial view using this code: Load the Partial view to the DIV          $( "#divdetail" ).load( ' @ Url.Action( "_Detail" , "GEMS_BCRpt" ) '  +  "?ID="  + ID );   <script>     $(function() {         $("#btn").click(function() {             var id = 10;             var valoare = 'test';             var url = '/TestingImages/Index2?Id=' + id + '&valoareselectata=' + valoare;             window.location.href = url;         });     }) </script> <input id="btn" type="button" value=“submit"/> function changedet(ID) {             $( "#divdetail" ).load( ' @ Url.Action( "_Detail" , "GEMS_BCRpt" ) ' + "?ID=" + ID );     }
Read more

Cannot Call Stored Procedure using Entity Framework

 How to call Stored Procedure using Entity Framework? First you have to Add the SP to Entity Framework Model. But you cannot see the SP name under Complex Types or Function Model under Model Browser. It lies with your SP that using Temp table. If you are using Temp Table in your SP, you must add SET FMTONLY OFF;    On top of the SP, and re-add the SP, the SP will be usable in Entity Framework.
Read more